Forum Discussion

JamesRees's avatar
JamesRees
New Contributor III
2 years ago

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.

  • chul's avatar
    chul
    Contributor III
    2 years ago

    ah missed that thanks

  • 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.