Average of Sum

[#1]

Hi,

I want to AVERAGE of SUM(pos) where there is n numbers of pos in particular month.

i have to take the month wise sum of pos and average of pos which is calculated month on month

so in this scenario how to use aggr function.

thanks in advance

Arun

[#2]

try Avg( Aggr( Sum(pos) , Month) )

[#3]

For me this does the trick; thanks JJJ