function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
vikram chandra dandamrajuvikram chandra dandamraju 

I want to display the percentage on reports is their a way to calculate and display the percentage on reports

NagendraNagendra (Salesforce Developers) 
Hi Vikram,

firstly, you didn't specify on which you want to calculate the percentage and display them on the report.

For example, if you want to calculate the percentage of status field and display them on the report then I would suggest you go through the below steps.

1. Go to the report type category, then double-click Add Formula.
2. Enter a unique name to the formula as you want it to appear on your report.
3. In the "Description" field, enter a brief description of the formula.
4. From the "Format" picklist, select Percent.
5. Under "Decimal Places," select the number of decimal places to be displayed.
6. Select the Display Area where the calculated formula should be displayed – select Grouping1 to calculate percentage according to rows.
7. Build your formula:
To display the percentage of fields by grouping at a summary level, select the RowCount to consider the total number of rows in each grouping and use the formula structure PARENTGROUPVAL(summary_field, grouping_level)
Complete Formula:  RowCount / PARENTGROUPVAL(RowCount, GRAND_SUMMARY)

You need to use the RowCount field and not the Status field to calculate the percentage.

Hope this helps.

Kindly mark this as solved if the reply was helpful.

Thanks,
Nagendra