Scenario:
I have a set of data as below, where i need to showcase the report status in a label as comments:
Report1 | Report2 | Report3 | COMPLETENESS STATUS | ACCURACY STATUS | TIMELINESS STATUS | AREA | Currency |
5 | 3 | 2 | Not Completed | No | No | USA | USD |
3 | 5 | 6 | Not Completed | No | No | USA | USD |
Solved! Go to Solution.
Hi @ikarthik ,
Try this
"Completness :" &
CountRows(
Filter(
Source,
Currency="USD",
AREA="USA",
'COMPLETENESS STATUS'="Not Completed"
)
) &
" Report(s) not Completed" & Char(10) &
"Accuracy :" &
CountRows(
Filter(
Source,
Currency="USD",
AREA="USA",
'ACCURACY STATUS'="No"
)
) &
" Report(s) Inaccurate" & Char(10) &
"Timeliness :" &
CountRows(
Filter(
Source,
Currency="USD",
AREA="USA",
'TIMELINESS STATUS'="No"
)
) &
" Report(s) not Impacted"
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Use Char(10) Example:
Hi @ikarthik ,
Try this
"Completness :" &
CountRows(
Filter(
Source,
Currency="USD",
AREA="USA",
'COMPLETENESS STATUS'="Not Completed"
)
) &
" Report(s) not Completed" & Char(10) &
"Accuracy :" &
CountRows(
Filter(
Source,
Currency="USD",
AREA="USA",
'ACCURACY STATUS'="No"
)
) &
" Report(s) Inaccurate" & Char(10) &
"Timeliness :" &
CountRows(
Filter(
Source,
Currency="USD",
AREA="USA",
'TIMELINESS STATUS'="No"
)
) &
" Report(s) not Impacted"
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Use Char(10) Example:
Wow! It's worked. Appreciate for quick response 😀
User | Count |
---|---|
179 | |
120 | |
87 | |
44 | |
41 |
User | Count |
---|---|
245 | |
156 | |
127 | |
77 | |
73 |