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

       

      Regards

       

       

      Muhammad