2 Replies Latest reply: May 24, 2016 9:50 AM by Mark Graham RSS

    Calculating average in set analysis

    Mark Graham

      (Avg(Aggr(Sum({<[Recent 7 Days] -= {'-'}>}eaches ),[Recent 7 Days]))) /


      Avg((Aggr(Sum({<[Recent 7 Days] -= {'-'}>}duration_logged_in_Hrs ),[Recent 7 Days])))


      Hi all,

      i'm using above script to calculate average of 'eaches' consumed in recent 7 days.

      Although it is giving me the average, i do not wanna divide the average eaches in recent 7 days with

      average hrs logged in.



      I'm trying to divide sum of eaches / sum of logged in hrs. (Still having the condition Recent 7 Days <> '-'

      Not working:

      (Aggr(Sum({<[Recent 7 Days] -= {'-'}>}eaches ),[Recent 7 Days]))) /


      ((Aggr(Sum({<[Recent 7 Days] -= {'-'}>}duration_logged_in_Hrs ),[Recent 7 Days])))



      Any help is highly appreciated!