Skip to main content
Drew Elston (Optimizely) 님이 #Sales And Marketing에 질문했습니다

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개
  1. 2019년 4월 10일 오후 2: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