Calculated Dimension Error

[kelly_jacobsma]

Im fairly new to Lumira and trying to do a basic calculated dimension and of course, getting an error. I am hoping this is simple and someone can just point out what is wrong with my syntax - it doesn't like my 'in' piece of the syntax. It does fine when its just an equal (=) sign. if {DRG Code} = 34 then "CARDIO" else if {DRG Code} = 36 then "ORTHO" else if {DRG Code} in (35,36,163,164) then "PEDS" else 0 Any thoughts or help are greatly appreciated! Kelly Jacobsma

[former_member229472 · Accepted solution]

You should put the options in the IN section within square brackets [ ].

[varunanand]

Hi Kelly,

The formula does get long when using if then else condition. The Group by Selection under Data Actions should be able to get the desired results.

Thank you,

Varun Anand