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