Skip to main content
Member
Nov 19, 2023 12:23 AM UTC
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 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,

 

db_pdxAnswer
Contributor
Nov 21, 2023 3:43 PM UTC

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

8 replies

Employee - Guide
Nov 20, 2023 5:08 PM UTC

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

Veteran
Nov 21, 2023 7:27 AM UTC

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.

Employee - Guide
Nov 21, 2023 2:47 PM UTC

ah missed that thanks

JamesReesAuthor
Member
Nov 21, 2023 3:39 PM UTC

Thanks - will raise a support ticket.