1 Reply Latest reply: May 15, 2014 5:01 AM by Michele Barini RSS

    expression for YTD Average

    Rhona Corcoran

      Hi

       

      Can someone tell me what is wrong with this expression:

       

      =(Sum({$<ActivityKey ={10},serviceprovider={H}>}ActualValue)/Count({$<ActivityKey ={10},serviceprovider={H}>}ActualValue))/count(ReferredMM)

       

       

      I have a straight table with expressions for each month which shows an average per month.  Then this above is to show the total of these months or the overall figure which is an average divided by the number of months to get a YTD average.

       

      Thanks

       

      Rhona