Last Month cumulative sum

Anonymous — Fri, 20 Jun 2014 09:15:11 GMT

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

Re: Last Month cumulative sum

Gysbert_Wassenaar — Fri, 20 Jun 2014 09:18:39 GMT

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