How to Base one Measure's value off another

#1

I have a formula measure that is working great and is doing almost everything I want.

To make it perfect, I want to set the value to zero when another Measure in my metric set is zero, otherwise use the formula I have created. Seems like it should be easy to do but I cannot figure it out (I really wish there was an IF function in the formula builder). Anyone have any ideas?

Thank you!

#2

There actually is an option to add “if” statements - that is under the formula advanced mode which you can access from the right hand side of the formula bar. This is detailed here: Formula advanced mode

1 Like