8 Replies Latest reply: Jun 19, 2017 8:55 AM by Sunny Talwar RSS

    Returning number of employees over their total hours

    James MacDonald-Fawcett

      Hi All,

       

      The question I have is in relation to returning the number of employees where the hours totalled are greater than 72.

       

      Currently this returns as a chart fine using the below:

       

      =if($(v_exp_planned_hours_employee)>72,$(v_exp_planned_hours_employee),0)

       

      When using employee_code as a dimension and v_exp_planned_hours is a variable to get

       

      How could this be converted to just return the number of employees that have hours greater than 72?

       

      Many thanks!

       

      James