10 Replies Latest reply: Feb 8, 2012 9:08 AM by jkizanis RSS

    Totals expression calculation issue

      Hello,

       

      In the QlikView file attached, I would like to see only employees EMP1 to EMP4 and EMP6 to EMP9 because employees EMP5 and EMP10 to EMP18 haven't worked and "Total Hours Worked" is zero.

       

      Furthermore, the last line that calculates the totals, the "Total Employee Cost" and "Employee Hourly Cost" should be calculated only by the employees that have hours. The current calculations are wrong.

       

      Thanks,

       

      --John