Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
sum({<DateKey={">=DateKey(addmonths(Monthstart(max(DateKey),-1)))<=Date(addmonths(max(DateKey),-1))"}>}RoomsSold)
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
sum({<DateKey={">=DateKey(addmonths(Monthstart(max(DateKey),-1)))<=Date(addmonths(max(DateKey),-1))"},FinancialCode =- {9999}, ProfitCentreCode = {2}, Date= >}RoomsSold)
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
Hi there, any feedback as yet please?