Date filter not working on row override in Cube View

[JamesRees]

Hi - I am having issues with using the PriorPeriod12() in a row override. The following filter is supposed to use the PriorPeriod12() function to return the same month last year (e.g. input of 2023M10 should return 2022M10). 

GetDataCell(T#|!Param_Select_Time!|:U2#Alt_AandG:V#Trailing12MonthTotal/A#EndingACV:V#MTD:U2#Alt_AandG:T#PeriodPrior12(|!Param_Select_Time!|)))

However, when I replace the T#PeriodPrior12(|!Param_Select_Time!|) with say 2022M10, then the override works. Any ideas of a work-around?

Thanks,

[chul]

You've got T# in your GetDataCell filter twice.

[NicolasArgente]

@chul It is because he is dividing.
@JamesRees please use the divide function and not the /. it is not good practice because if you divide by zero it will return an error.
Now, for your issue. Did you try to replace with T#PeriodPrior12(|GlobalTime|) just for testing purposes? Also can you print your parameter to see what it actually returns? I presume the parameter is the issue.

[chul]

ah missed that thanks

[JamesRees]

Thanks @NicolasArgente. Noted on the divide function. Tried both Global time and WF time but with the same issue. It works fine in the Cube View filters... it's just on the overrides that it's providing a problem.

[NicolasArgente]

Well... if it is working elsewhere then I do not know what to say. It might be an "unexpected event" 😉. Can you contact support or anyone else can confirm the error?

[db_pdx · Accepted solution]

Try: T#[PeriodPrior12(|!Param_Select_Time!|)].  Notice the extract square brackets [ ].

[JamesRees]

Thanks @db_pdx  - that solved it.

[JamesRees]

Thanks - will raise a support ticket.