You need to sign in to do that
Don't have an account?
Ghilli
CASE Funtion with checkbox values
Hi Friends,
IMAGE(
CASE(Marked_for_deletion__c,
"FALSE", "/img/samples/light_green.gif",
"TRUE", "/img/samples/light_red.gif",
"/s.gif"),
"Marked For Deletion Flag")
Here Marked_for_deletion__c is a checkbox. so i used TRUE and FALSE in the case functions.
But its showing error Like " Error: Incorrect argument type for function CASE(). "
Kindly help me out in this.
Thanks.
From the documentation:
CASE functions cannot contain functions that return true or false.
Since a checkbox is a simple true/false element, the 'else_result' is useless and the following statement is also more compact:
IMAGE(
IF(Marked_for_deletion__c, "/img/samples/light_red.gif", "/img/samples/light_green.gif" ), "Marked For Deletion Flag")
HTH - Andreas
CASE(TEXT(Rating),
"Hot", IF(ISBLANK(Title),1,0),
"Warm",IF(CONTAINS(Title, "NK"),1,0),
0),
TRUE,FALSE)
Gives error: Incorrect parameter type for function 'IF()'. Expected Boolean, received Number