Rolling 3 Month Avg

[Hum1]

Is there a way someone can explain to be why my rolling 3 months Avg (3 MMM) is displaying large numbers.

Expression for Rolling 3 Month (3 MMM) :

if(Month='Apr', sum(aggr(rangesum((sum((BookAmt/Act + OL)))),Month)),
if(Month='May' ,sum( aggr( rangesum( above( sum((BookAmt/Act + OL)/2)),0,1 ),Month)) ,
sum( aggr( rangesum( above( sum(((BookAmt/Act + OL)/3)),0,3) ),Month))))

[Arthur_Fong]

Try:

if(Month='Apr', sum(aggr(rangesum((sum({<Month={'Apr'}>}(BookAmt/Act + OL)))),Month)),
if(Month='May' ,sum( aggr( rangesum( above( sum({<Month={'May'}>}(BookAmt/Act + OL)/2)),0,1 ),Month)) ,
sum( aggr( rangesum( above( sum(((BookAmt/Act + OL)/3)),0,3) ),Month))))

[Brett_Bleess]

Did Arthur's suggestions work?  If so, do not forget to return to your post and use the Accept as Solution button on his post to give him credit for the assistance and to let other Members know that worked.  If you are still working upon things, please leave an update.

A useful area for how-to type solutions is here, there are over 700 posts in this area from our internal experts, so worth bookmarking for future reference:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett