Count Status Work in report defiition
hi all,
I want to count total of New and Pending-Approval StatusWork (total <New(27) + Pending-Approval(2)>=29).
How to set Report Definition to get that?
Anyone can help?
Accepted Solution
Pegasystems
IN
You can configure the report in this fashion
The report uses a new SQL function CaseWhenStatus (code below)
And when we run the report (with some test data), this is how the output looks
Hope this addresses your requirement
Pegasystems
IN
Do you also need the count of "Resolved-Completed" and "Resolved-Rejected" from the report along with the combined count of "New" and "Pending-Approval"?
If yes, you can have a custom SQL function pyStatusWork column to consider "New" and "Pending-Approval" as one group. You can look at the pxCaseWhen SQL function as an example.
KBRU
ID
no, I just need to count "New" and "Pending-Approval" as one group. I have already look pxCaseWhen SQL function. but I didn't get it. Can You give me an example with picture about that?
I want to sum Status Work that contains Pending and Status Work is equal New.
Any Clue?
Accepted Solution
Pegasystems
IN
You can configure the report in this fashion
The report uses a new SQL function CaseWhenStatus (code below)
And when we run the report (with some test data), this is how the output looks
Hope this addresses your requirement