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:
As the Renewal % field should be pulling 505,034 / 599,312. Any suggestion on how to pull this?
Thanks!
-Drew
답변 3개
Are you trying to do something like this?
Opportunity.Renewal_TCV__c:SUM
/
PARENTGROUPVAL(Opportunity.Original_Amount__c:SUM, GRAND_SUMMARY)