6 Replies Latest reply: Jun 3, 2016 3:24 AM by Corinna Theiß RSS

    sum of Top 10 weeks



      I am looking for an expression for the below scenario..


      I have employeeName, week, hours information.


      now i want to calculate the sum of hours of an employee who exceeds 20 hours a week for more than 10 weeks.


      To be more clear...

      an employee who  spent more than 20 hours for more than 10 weeks, now i need sum of these 10 weeks hours.

      kindly help me with the expression ..