You need to sign in to do that
Don't have an account?
Formula w/ 2 fields added together for Case parameter
I am trying to create a formula field with a Case statement that has 2 other number fields added together for it's parameter. It looks like this:
CASE ((Custom_Number Field_1__c + Custom_Number Field_2__c), >=100, "Value is Greater than 100", >=50, "Value is Greater than 50", >=1, "Value is Greater than 1")
I keep trying to alter the syntax slightly, but no matter what I get one of 2 error messages:
Error: Incorrect number of parameters for function 'CASE()'. Expected 6, received 7
or
Error: Syntax error. Found '>='
What am I doing wrong? Is it even possible to do a Case statement like this or do I have to switch to an IF?
The Case function has the following Syntax - CASE (Expression, Value1, Result1, Value2, Result2, ......, else Result) where in the Value parameter cannot accept comparitive values like >100 or >=100. Try using an IF Statement; it would look something like this:
That's what I wound up doing. I just tried to use a CASE to make it less verbose.