Skip to main content
I am trying to leverage an Advanced Formula in Data Management and where I have successfully used them before for IF-THEN-ELSE type scenarios, does anyone know if you can do IF-THEN-ELSIF-THEN-ELSE type scenarios?



I tried 



case when (X < Y and X is not null) then 0 else (X > Y and X < Z) then 50 else (X > Z) 100 end



That didn't work (neither did removing the brackets) so I'm thinking either my syntax is bad or this is not possible.  Any feedback?
Figured this out with a little help from Gainsight:



case when X < Y then 0 when (X > Y and X < Z) then 50 else 100 end



Looks like you go straight into a "when" statement after the first value option. Not need for a "then" 



And just tie it off with an "else # end"

Thanks for this post. I have done this once or twice before, but I couldn’t remember the syntax.


This post saves me every time I try to set up one of these Advanced Formula fields!


I have similar use case and it does not seem to work if I use two variables. Has anyone tested this - case when x=0, then A case when (x >0 and y <100) then B else 0 end


I have similar use case and it does not seem to work if I use two variables. Has anyone tested this - case when x=0, then A case when (x >0 and y <100) then B else 0 end

Hi ​@parimala_agnihotri, I'm not sure if you copied your formula exactly, but if you did, you'll just need to remove the comma. The rest of the syntax looks correct. 
 


Reply