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?
Best answer by darkknight
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"