Crystal Report - Group Percentage
Crystal Report - Group Percentage
(OP)
Hi,
I am aware this has been dealt with before. my apologise but I am new to Crystal and just cant get me head round this.
I am trying to find a percentage for a group but the figure keeps repeating for each group.
I am not sure how to reset my formula below
(Count({JobHdr.JOBNO})/Sum({@count of FTF YES}))*100
Please help and advise - much appreciated.
Kind Regards
I am aware this has been dealt with before. my apologise but I am new to Crystal and just cant get me head round this.
I am trying to find a percentage for a group but the figure keeps repeating for each group.
I am not sure how to reset my formula below
(Count({JobHdr.JOBNO})/Sum({@count of FTF YES}))*100
Please help and advise - much appreciated.
Kind Regards
RE: Crystal Report - Group Percentage
If you need to create a manual summary, and if we assume you are getting the correct number in the denominator and that you want a percent of the report total for each group, then you just need to add the group condition to your count, as in:
Count({JobHdr.JOBNO},{table.groupfield})%sum({@count of FTF YES})
You can use % instead of multiplying by 100.
I also wonder whether a distinctcount might be needed (if you have any duplicate rows).
-LB