18 Replies Latest reply: Oct 31, 2011 9:03 AM by Marc Livingston RSS

    Trying to show overtime vs standard hours per week. Need to calculate based on hours per employee

      I am trying to show a chart that shows Hours per week, and Over time hours per week.


      I am running into a problem where I need to tell the expression to take a summary for the week based on the employee, and if that number is over 40 to subtract 40 to get the over time hours.


      How can I tell it to do this?




      Employee       Hours per week


      1                    30

      2                    50

      3                    20

      4                    60

      5                    40


      The correct overtime for this example is 30. Standard hours is 170.


      Calculating Standard as 40hr/employee would show 200 standard hours and 0 over time.