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:




      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!