2 Replies Latest reply on Aug 22, 2016 4:52 AM by Muhammad Khan

    Calculated field do not cover all fields

    Muhammad Khan

      Hello Everyone

       

      I am facing some issues with my calculated filed, It doesn't cover all of the columns as shown in below picture. I also want to add some more columns to show min and max for 2nd last and last column.

       

      if ATTR([Rate of Pay Type]) = 'Hourly' then AVG([Final Rate of Pay])

      elseif attr([Rate of Pay Type]) = 'Daily' then AVG([Final Rate of Pay] / 8)

      elseif attr([Rate of Pay Type]) = 'Weekly' then AVG([Final Rate of Pay]) / ([Hours / wk])

      elseif attr([Rate of Pay Type]) = 'BiWeekly' then AVG([Final Rate of Pay]) / ([Hours / wk] * 2)

      elseif attr([Rate of Pay Type]) = 'Monthly' then AVG([Final Rate of Pay])/ ([Hours / wk] * 4)

      elseif attr([Rate of Pay Type]) = 'Annually' then AVG([Final Rate of Pay])/([Hours / wk]*50)

      end

       

      Screen.png

       

      Regards

       

      Muhammad