Calculating percentage in RD through Sub Report
Hi,
There are two sub reports,one is to count the total pyID & another one is to count of pyID with New status. Two sub reports are working fine. Now I am trying to calculate percentage in main report definition using sub report columns with pxMultiple & px Divide FA. But getting below error. Could anyone tell what is going wrong here?
Screenshots are attached.
Thanks,
Kousik
Capgemini Sverige
SE
Hi Koushik,
Refer the below page-
Pegasystems Inc.
US
Kousik,
Could you provide your PegaRULES logs and a rules trace of when you run try to run the report (with DB Query event enabled).
Thanks!
Pegasystems Inc.
US
Hi Kousik,
Can you do an iterative approach to find out which specific operation is causing the error? That is:
1) Start with just the 2 counts, to make sure they display (and are non-zero - you may need to add a condition to account for this and avoid dividing by zero).
2) See if you can involve either sub-report count in a simple function alias (e.g., total pyID divided by a fixed number like 10).
3) See if the "Divide by" of the 2 counts works (without the Multiply by 100).
Genome
US
Hi Kousik,
One of the input values may be null. Try adding another SQL function "ZeroIfNull". In the attached screenshot, I'm getting S1(Fail -count) and S2(Pass - count) from subreports to calculate fail % and pass % .