Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Terry_0101Terry_0101 

How to add numbers in formulas?

Hi - how to fix this formula?   If record type is Cake, then make it 0.  Then proceed to add up the Amounts 1-3.

IF( 
RecordType.Name = "Cake",0,
(Amount_1__c + 
Amount_2__c +
Amount_3__c)
Akhil AnilAkhil Anil
Hi Terry,

Your formula looks correct according to the requirement posted.

What's the issue that you are facing ?
Terry_0101Terry_0101
Not working.  Maybe this to clarify: 
If record type is Cake, then exclude those values under that record type.
Then proceed to add up the Amounts 1-3 related to other record types.
Rakesh ARakesh A
If Amount is a text data type convert it to number as below.
IF( 
RecordType.Name = "Cake",0,
(VALUE(Amount_1__c) + 
VALUE(Amount_2__c) +
VALUE(Amount_3__c))
)
and if formula return type should be Number