Formula help - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Trude RustadTrude Rustad 

Formula help

Can anyone pls help me get this formula right?

It is a Sumay Formula, 

((CDF1:SUM)-(Opportunity.DownSellTotalARRValue__c.CONVERT:SUM))-
(CASE(STAGE_NAME,
'Value Assessment',0
'Proposal',0
'Negotiation',0
'Closed Won',0
Opportunity.RenewalTotalARRValue__c.CONVERT))
/Opportunity.Legacy_Contract_ARR__c.CONVERT:SUM

I am getting this error message: 
Warning
Syntax error. Missing ')'

I am getting lost in the Bracets ....

Best Answer chosen by Trude Rustad
Karan KeharKaran Kehar
Trude,
Please remove the .CONVERT and then use the field Opportunity.RenewalTotalARRValue__c

All Answers

Trude RustadTrude Rustad
Hi Karan, 

Thanks for helping - did as you suggested, error message then is:
Warning
Field Opportunity.RenewalTotalARRValue__c.CONVERT does not exist. Check spelling.

 
Karan KeharKaran Kehar
Trude,
It should be Opportunity.RenewalTotalARRValue__c.CONVERT:SUM right?
Trude RustadTrude Rustad
yes
Trude RustadTrude Rustad
Thank you for that, 

((CDF1:SUM)-(Opportunity.DownSellTotalARRValue__c.CONVERT:SUM))-
(CASE(STAGE_NAME,
'Value Assessment',0,
'Proposal',0,
'Negotiation',0,
'Closed Won',0,
Opportunity.RenewalTotalARRValue__c.CONVERT:SUM))
/Opportunity.Legacy_Contract_ARR__c.CONVERT:SUM

However ten it gives me this error message:
Incorrect parameter type for function 'CASE()'. Expected Object, received Text
Trude RustadTrude Rustad
I am not sure I follow??
Karan KeharKaran Kehar
Trude,

Some confusion due to comments being to and fro. Can you try 

((CDF1:SUM)-(Opportunity.DownSellTotalARRValue__c.CONVERT:SUM))-
(CASE(STAGE_NAME,
'Value Assessment',0,
'Proposal',0,
'Negotiation',0,
'Closed Won',0,
Opportunity.RenewalTotalARRValue__c))
/Opportunity.Legacy_Contract_ARR__c.CONVERT:SUM
Trude RustadTrude Rustad
That gives me this error message:
Warning
Field Opportunity.RenewalTotalARRValue__c.CONVERT does not exist. Check spelling.

Hm... I am confused for sure.
Karan KeharKaran Kehar
Trude,
Please remove the .CONVERT and then use the field Opportunity.RenewalTotalARRValue__c
This was selected as the best answer
Trude RustadTrude Rustad

Sadly it gives me the same error message: 

Field Opportunity.RenewalTotalARRValue__c does not exist. Check spelling.
IfI user the field finder the field name is: Opportunity.RenewalTotalARRValue__c.CONVERT...

Trude RustadTrude Rustad
I finally managed - thank you so much for your help :-)

I Did this in the Row level Formula: 
(CASE(STAGE_NAME, 
'Closed Lost',0,
Opportunity.RenewalTotalARRValue__c.CONVERT+Opportunity.CrossSellTotalARRValue__c.CONVERT+Opportunity.UpsellTotalARRValue__c.CONVERT))-
(IF(PROBABILITY=0.30,Opportunity.RenewalTotalARRValue__c.CONVERT,0))-
CASE(STAGE_NAME,
'Value Assessment',0,
'Proposal',0,
'Negotiation',0,
'Closed Won',0,
Opportunity.RenewalTotalARRValue__c.CONVERT)

Because of the limitations i did the last part in the Summary formula: 

((CDF1:SUM)-(Opportunity.DownSellTotalARRValue__c.CONVERT:SUM))
/Opportunity.Legacy_Contract_ARR__c.CONVERT:SUM

Feels so good to finally have solved this one, thank yu soo much for your help