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

    sum of Top 10 weeks

    Dileep Reddy

      Hi,

       

      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 ..


      Thanks,

      Dileep.