My brain is all out of smarts this week, so hive mind I need your help.
Writing a report to measure conversion by both numbers of closed opportunities as well as by revenue. The number formula is all done and working, its the revenue one I am struggling on!
This is my report, it is grouped by Opportunity owner and then Stage...
Essentially the formula I am trying to write is Total Price Contracted/Subtotal of Total Price.
I think I need a PARENTGROUPVAL formula and this is as far as I have got with it, but clearly, it's not giving me the right answer, so I've done something wrong and I've played with it so much now I can't see for looking! The answer I want to get is 74.05%. By the way, we have 3 closed stages, Contracted, Closed Lost, and Declined.
Any help would as always be greatly appreciated.
Thanks so much
Tracy
Eric Praud (Activ8 Solar Energies) Forum Ambassador
Ok, thanks for the explanation.
You'll first need to create a formual field on Opportunities, or a row level formual (not summary formula) on the report if you won't use it besides this report.
The formula will be something like:
IF(TEXT(StageName)="Contracted", TotalPrice__c,0)
You can now use a summary formula:
Formula:SUM/TOTAL_PRICE:SUM