Skip to main content

Hi SF Community, 

I am having trouble trying to build a formula in an opportunity report which would calculate our total renewed %. For simple math terms, it would be (Renewal Total Contract Value at 100%) / All %s of Original Renewal Amount. Below is a screenshot of what I'm working with:

Custom formula help

User-added image

As the Renewal % field should be pulling 505,034 / 599,312. Any suggestion on how to pull this?

Thanks!

 

-Drew

 

3 Antworten
  1. 10. Apr. 2019, 14:24

    Are you trying to do something like this?

    Opportunity.Renewal_TCV__c:SUM

    /

    PARENTGROUPVAL(Opportunity.Original_Amount__c:SUM, GRAND_SUMMARY)

     

    Are you trying to do something like this?Opportunity.Renewal_TCV__c:SUM/PARENTGROUPVAL(Opportunity.

     

    User-added image
0/9000