Skip to main content

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...

PARENT GROUP VAL Formula help required

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.

 

Formula 1.png

 

Any help would as always be greatly appreciated.

 

Thanks so much

Tracy

 

#Formulas #Report Formulas

4 risposte
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    9 set 2021, 13:16

    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