Skip to main content
Topics#Data ManagementPriyanka Taunk の質問
Priyanka Taunk (Reevoo) が「#Data Management」で質問
2013年10月2日 8:51

Trying to create a formula field so it checks if there is an override field (currency)

Trying to create a formula field so it checks if there is an override field (currency), if there isn't an override field, it should calculate the value based on two other fields (i.e. contract length and monthly rev).

 

what am i missing in this below formula

 

BLANKVALUE(ACV_Override__c, Monthly_Revenue__c * MIN( Contract_Length__c ,12))

 

it is accepting the formula but when i look at the opportunity reports, the formula field only picks up the over ride amount (when there is one) , if not, then it leaves it blank instead of calculating the 'Monthly_Revenue__c * MIN( Contract_Length__c ,12'

 

Thanks
1 件の回答
  1. Jeff May
    2013年10月2日 9:09
    Try using an IF function

     

    IF(ISBLANK(ACV_Override__c), Monthly_Revenue__c * MIN( Contract_Length__c ,12), ACV_Override__c)
回答を記入...
0/9000