Forum Discussion

mteich's avatar
mteich
New Contributor III
2 years ago

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

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:

Thanks!

Cube View
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    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.

    • mteich's avatar
      mteich
      New Contributor III
      2 years ago

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

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