12 Replies Latest reply: Dec 1, 2016 5:41 AM by Moses Zwane RSS

    Calculate Averages in set analysis

      Good morning,

       

      I am trying to calculate averages for the attached file. The formula I have used to calculate

      Total_PreviewTime=Sum ({<PreviewedFirst={1}>}PreviewTime) and I want to calculate the Average Total_PreviewTime  and similarly for

      Total_CallTime=sum(CallTime) I want to calculate Average Total_CallTime

       

      PFA,

      Thanks