Crystal Report - Group Percentage

[shamaM]

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

 

[lbass]

First, you can use insert->summary to select a percentage summary at the group or report level.

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