Skip to main content
J
JamesRees
November 19, 2023
Solved

Date filter not working on row override in Cube View

  • November 19, 2023
  • 3 replies
  • 1 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,

 

Best answer by db_pdx

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

3 replies

C
chul
November 20, 2023

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

N
NicolasArgente
November 21, 2023

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.

C
chul
November 21, 2023

ah missed that thanks

J
JamesReesAuthor
November 21, 2023

Thanks - will raise a support ticket.

Terms & ConditionsAccessibility statement