4 Replies Latest reply: May 7, 2015 3:13 AM by jagan mohan rao appala RSS

    Average for a Team

      Hi Friends ,

       

      I have a requirement , where i have to find the average for a Team  and Individual.

      i was able to find the average for individual. The expression used is

      =((Sum({$<Type = {'Break Time'}>} Duration)/60)/ (Count( DISTINCT{$<Type = {'Break Time'}>} Date)))

      Now i have to find the average for the team. How do i acheive it.

       

      The Team header is StaffUnit.

       

       

       

      Regards,

      Senthil