Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try iMonth={'$(=max(iMonth)-1)'}