Assuming I have these formula fields returning currency values:
formula_field1__c : (currency1__c * currency2__c)
formula_field2__c : (currency3__c * currency2__c)
*Note that currency3__c is also a formula field:
currency3__c: (currency4__c - currency1__c)
Now, this is what I am trying to accomplish:
Every time a picklist value is equal to 'Value1', it must return the value of formula_field1__c
, and Every time a picklist value is equal to 'Value2', it must return the value of formula_field2__c
.
I created another formula field, formula_field3__c
:
IF(ISPICKVAL(picklist__c,'Value1'),formula_field1__c,null) +
IF(ISPICKVAL(picklist__c,'Value2'),formula_field2__c,null)
I don't encounter any errors, but every time I save a record, formula_field3__c
doesn't have any value.