Skip to main content
Contributor
October 28, 2022
Solved

All Months in Prior Year based on Global Time

  • October 28, 2022
  • 1 reply
  • 0 views

Hello.

I am trying to create a column set showing M1-M12 for the previous year based on Global Time. I can do this successfully using WFYear and POVYear as shown:

T#YearPrior1(|WFYear|).Base
T#YearPrior1(|POVYear|).Base


However, this syntax generates an error  =>   T#YearPrior1(|GlobalYear|).Base


I can get close using  =>  T#GlobalYear.Prior1.Base
But, it adds a column for the year which we do not want:

2022-10-28_11-25-17.png

 

Thanks,
Bil Brandon

Best answer by Hweeli

Hi,

try T#YearPrior1(|Globaltime|).Base

1 reply

HweeliOneStream EmployeeAnswer
OneStream Employee
October 31, 2022

Hi,

try T#YearPrior1(|Globaltime|).Base