expression for YTD Average

[rcorcoran]

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

[bbi_mba_76]

Hi,

without the document.. Maybe it is due to a missing distinct in the count?