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 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,

 

Cube View
Parameters
Reports
  • db_pdx's avatar
    db_pdx
    2 years ago

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

  • chul's avatar
    chul
    Contributor III
    2 years ago

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

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