I am currently having a Currency field on Opportunities (say 'My_Revenue__c'). Now, I am trying to calculate the sum of 'My_Revenue__c' for all Closed Won Opportunities divided by the sum of All Closed Opportunities (Closed Won + Closed Lost).

Basically, I want the percentage of the amount. To that, I tried using the PARENTGROUPVAL and made the below formula:


For the above formula, I grouped on the basis of Stage. Also, am only including the Closed Opportunities in this report. But, it is giving me the wrong percentage.

Am I on the right path? I am a bit confused whether to put this on 'All Summary Levels' or 'Grand Total Only' or 'Specific Groups'.

Kindly help.

1 Answer 1


I figured it out. I used the below formula:


Also, I applied this to the 'Specified Groups' Stage. And BOOM, I got the exact results.

Hope this helps.

You must log in to answer this question.

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