Skip to main content
July 19, 2023

Combination of Year() and PeriodNext1() not working in a GetDataCell

  • July 19, 2023
  • 1 reply
  • 0 views

I am trying to utilize a combination of Year() and PeriodNext1() within a GetDataCell, and it's not working. The combination of Year() and Period() within a GetDataCell works if you surround it with brackets, but once you add the Next1, it will not work. Any ideas as to how I can accomplish this?

Example of GetDataCell with Year() and Period() working fine: 

GetDataCell(BWDiff(V#MTD:T#|!Prompt_TimeMonth!|:S#|!Prompt_Scenario!|, V#MTD:T#[Year(|!Prompt_CurrentYear_Comp2!|)Period(|!Prompt_TimeMonth!|)]:S#|!Compare_Scenario2!|))

Example of GetDataCell with Year() and PeriodNext1() which gives an error:

GetDataCell(BWDiff(V#MTD:T#PeriodNext1(|!Prompt_TimeMonth!|):S#|!Prompt_Scenario_FW!|, V#MTD:T#[Year(|!Prompt_CurrentYear_Comp1!|)PeriodNext1(|!Prompt_TimeMonth!|)]:S#|!Compare_Scenario1_Bgt!|))

Error Message Received:

mteich_0-1689801404303.png

Thanks!

1 reply

July 20, 2023

Does it work with PeriodPrior1 ? If yes, then I'd say it's a bug specific to PeriodNext1.

I would open a case with Support anyway.

mteichAuthor
July 20, 2023

It does not work with PeriodPrior1 either. It only works with Period.

I'll open a ticket. Was hoping someone had found a workaround!