Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi :
Could some one help me,
if I need to use the following expression by substituting the SUM function with AVG
AGGR(NODISTICT(SUM({<PERIOD={$(=MAX(PERIOD))},YEAR={$(=MAX(YEAR))}>} Amount))), Category, Class)
when I tried using with AVG function the resulting number is erroneous and does not give the average.
Appreciate in advance any help that can be extended
Kumar
Hi,
You could write a script like
=AGGR(NODISTINCT SUM({<PERIOD={$(=MAX(PERIOD))},YEAR={$(=MAX(YEAR))}>} Amount), Category, Class)
Hope this helps
Thanks & Regards
Hi,
Try for avg script like
=Avg( AGGR( NODISTINCT SUM({<PERIOD={$(=MAX(PERIOD))}, YEAR={$(=MAX(YEAR))} >}Amount), Category, Class))
Hope this helps
Thanks & Regards
Hi, thanks Anand , but the result gives error in calculation