Calculated Metrics IF THEN ELSE statements

[Former Community Member]

Hi, i am trying to use if then else statements in a calculated metric to give me a column with all relevant numbers. However it will only generate the first 2 correctly then seems to stop, i have tried stripping right back but i cant seem to get some to work at all.

I am simply using a calculated metric to say If metric = A then value of X, else If metric = B, then value of Y, if metric = C then value = Z ELSE value 0

Any help please would be great! Thank you

[ntaillet · Accepted solution]

Hi Laura,

Conditional statement works fine, usually.

However, there could have a mistake in the metric definition: could you please share a screenshot of your custom metric with us?

Thanks,

Nicolas