Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Below expression working fine. as it display max month amount.
money(
FABS(
sum({$<year = {$(=max(year))}, Month = {"<=$(=max({<year={$(=max(year))}>} Month))>$(=max({<year={$(=max(year))}>} Month)-1)"}>} Amount/1000/$(ColumnDim98))
)
, $(vMoneyFormatK_GL))
I like to modify this expression to display previous month amount instead of current month amount. may i know how where should i make changes ? See my enclsoed QV Doc in my next post.
Paul
use this function: =num(AddMonths(vMaximumDate,-1))
where vMaximumDate is your currect date Year and month.
Enclosed my QV Doc here.
use this function: =num(AddMonths(vMaximumDate,-1))
where vMaximumDate is your currect date Year and month.