5 Replies Latest reply on Jul 20, 2016 10:40 AM by Luciano Vasconcelos

    Controlling Zero

    Muhammad Khan

      Hi All


      I am facing following issues in getting accurate results.


      1) I am calculating avg salary from two columns- "starting" and "final" but in some cases the starting salary is zero which effects my calculations. I want to ignore "starting salary" is zero.

      2) For calculating $ / hr and $ / wk I have a field called "Hours per week"  but in some fields it is zero, I want to use 40 as  if there is zero but I am not sure how to do it.


      For better understanding i have attached sample work for you.


      your help will be highly appreciated