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