Level 1

0% to

Level 2

Tip /

to gain points, level up, and earn exciting badges like the new
Mission!

View all

## Calculated Metrics IF THEN ELSE statements

laurab73463013
Level 1

Likes

0 likes

Total Posts

5 posts

0 solutions
View profile

laurab73463013
Level 1

Likes

0 likes

Total Posts

5 posts

0 solutions
View profile
laurab73463013
Level 1

15-07-2019

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

#### Accepted Solutions (1)

ntaillet
Level 2

Likes

4 likes

Total Posts

7 posts

1 solution
View profile

ntaillet
Level 2

Likes

4 likes

Total Posts

7 posts

1 solution
View profile
ntaillet
Level 2

16-07-2019

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