3 Replies Latest reply on Mar 29, 2018 12:55 PM by Jim Dehner

    Zero in the denominator

    Kelly McGrady

      Hi,

       

      So I need to know how to make a conditional statement or anything that will get me an outcome of .1 when I have a zero in the denominator of my calculated field.

      This is so that I can have 100% as the outcome of this eventuality. I'm comparing actuals to plan for reference. when the plan is zero the actuals are 100 percent over the plan.

       

      Thank you,

       

      Kelly