Crystal Report - Group Percentage

shamaM · Jun 20, 2018

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 · Jun 20, 2018

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Crystal Report - Group Percentage

shamaM

Technical User

lbass

Technical User

Similar threads

Part and Inventory Search

Sponsor