Set Expression Month = {"<=$(=max(Month)-1)"} Does not return last month sales

[paulyeo11]

Hi All

Below expression return current month sales correctly :-

Sum(Aggr(SUM({

<

year = {$(=only(year))},

Month = {"<=$(=max(Month))"},

rEVENUE={rEVENUE}

>

}Amount*1)/$(Columndim89)/1000, $(ColumnDim101)))

I modify the above exoression to get the last month revenue as below :-

Sum(Aggr(SUM({

<

year = {$(=only(year))},

Month = {"<=$(=max(Month)-1)"},

rEVENUE={rEVENUE}

>

}Amount*1)/$(Columndim89)/1000, $(ColumnDim101)))

I get null value , can some one advise me where i go wrong ?

Paul

[paulyeo11]

my qv doc

[sunny_talwar · Accepted solution]

Try this:

Sum(Aggr(SUM({

<

year = {$(=only(year))},

Month = {"<=$(=max(Month)-1)"}, month, year,

rEVENUE={rEVENUE}

>

}Amount*1)/$(Columndim89)/1000, $(ColumnDim101)))

[paulyeo11]

Hi Sunny

Thank you very much for your advise again. But i try your expression return 3374 , how to make it display 947  ? Same as Table 2

Paul