Previous months data

[Eugene007]

Hi there

I am trying to set an expression to show my previous month data on a live report without setting any dates selection.

Please see current expression that needs to be edited:

SUM({<DateKey = {">=$(=Min({<FYP = {"$(=$(vCurrFYP))"}>} DateKey))<=$(=NUM(Date(vToday)))"}, FinancialCode =- {9999}, ProfitCentreCode = {2}, Date= >} RoomsSold)

Kind regards

Eugene

[Chanty4u]

try this

sum({<DateKey={">=DateKey(addmonths(Monthstart(max(DateKey),-1)))<=Date(addmonths(max(DateKey),-1))"}>}RoomsSold)

[Eugene007]

Hi Chanty4u

I need to keep this part of the expression: FinancialCode =- {9999}, ProfitCentreCode = {2}, Date= >} RoomsSold)

Please advise the full expression?

Also, your expression made all the MTD values zero.

Please assist

[Chanty4u]

sum({<DateKey={">=DateKey(addmonths(Monthstart(max(DateKey),-1)))<=Date(addmonths(max(DateKey),-1))"},FinancialCode =- {9999}, ProfitCentreCode = {2}, Date= >}RoomsSold)

[Eugene007]

Hi Chanty



Here is the report before any changes where I still have values:



[cid:image001.png@01D70F99.C6F38520]



Here I apply your expression:



[cid:image002.png@01D70F99.C6F38520]





This is the results, still zero values??



[cid:image003.png@01D70F99.C6F38520]



Please advise next steps?



Your assistance will be highly appreciated.



Kind regards

[Eugene007]

Hi Chanty

Here is the report before any changes where I still have values:

Here I apply your expression:

This is the results, still zero values??

Please advise next steps?

Your assistance will be highly appreciated.

Kind regards

[Eugene007]

Hi there, any feedback as yet please?