1 Reply Latest reply: Mar 1, 2011 12:46 PM by Rakesh Boorgu RSS

    Protect agains Dividing by 0

    HeyZeusChris

      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!