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

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