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,

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

Date filter not working on row override in Cube View

chul
OneStream Employee
2 years ago
You've got T# in your GetDataCell filter twice.
NicolasArgente
Valued Contributor
2 years ago
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
  OneStream Employee
  2 years ago
  ah missed that thanks
- JamesRees
  New Contributor III
  2 years ago
  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
    Valued Contributor
    2 years ago
    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?
JamesRees
New Contributor III
2 years ago
Thanks - will raise a support ticket.