Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression in a graph,
sum({<Date*={">=$(StartDate) <=$(EndDate)"}>} MetricOne)
/
sum({<Date*={">=$(StartDate) <=$(EndDate)"}>} MetricTwo)
This is supposed to divide metricone by Metric two. If MetricTwo is 0 I want the expression to just be 0. How can I do this?
Thanks!
cant you just use if(Metric2 = 0, 0, Metric1/Metric2) ?
That should be a straight one. Not sure if you are constrained by something else.