5 Replies Latest reply: May 14, 2014 7:30 AM by jagan mohan rao appala RSS

    Average of monthly figures

    Rhona Corcoran

      Hi I am trying to get an average for monthly figures but having no joy


      I have a straight table with expressions for Average National figures per month which are calculated figures themselves


      So the January expression is:


      =sum({$<ActivityKey ={10},ReferredMM={1},ServiceProviderType={H}>}ActualValue)/count({$<ActivityKey ={10},ReferredMM={1},ServiceProviderType={H}>}ActualValue)


      I want the table to show as follows:


      Jan   Feb   Mar   Average

      6.8   6.0     8.2    7.0


      I have tried to get the average but havent been successful


      Any help would be great


      Thank you