Multiple case statements in Advanced Formula?
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?
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"
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"
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.