Forum Discussion

JamesRees's avatar
JamesRees
New Contributor III
2 years ago
Solved

Date filter not working on row override in Cube View

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 2023M1...
Cube View
Parameters
Reports
  • db_pdx's avatar
    db_pdx
    2 years ago

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

NicolasArgente's avatar
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.

JamesRees's avatar
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's avatar
    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?

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    2 years ago

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

    • JamesRees's avatar
      JamesRees
      New Contributor III
      2 years ago

      Thanks db_pdx  - that solved it.