0

I have a report with that has a grand total of number of people. The report is grouped by a status. How can I create a formula that gives me the percent of people in each grouping divided by the grand total?

In this example I would need 357/5,754, the field name is People__c and the grouping is status

1 Answer 1

4

You can use the PARENTGROUPVAL in a report custom formula to calculate the percentages for each grouping.

You'd need People__c:SUM / PARENTGROUPVAL(People__c:SUM, GRAND_SUMMARY)

1
  • link to 'guide' broken
    – cropredy
    Oct 12, 2016 at 18:04

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .