Last Month cumulative sum

[Anonymous]

Hi,

This is cumulative sum (YTD) =sum({<iYear={$(vMaxYear)},iDate={'<=$(vMaxDate)'},iMonth=>}AMOUNT)

What expressions calculates up to the last Month clearly this doesnot work

=sum({<iYear={$(vMaxYear)},iMonth={'$(vPreviousMonth)'}>}AMOUNT)

Thanks

[Gysbert_Wassenaar]

Try iMonth={'$(=max(iMonth)-1)'}