Forum Discussion

bilbrandon's avatar
bilbrandon
New Contributor III
3 years ago

All Months in Prior Year based on Global Time

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:

 

Thanks,
Bil Brandon

  • Hi,

    try T#YearPrior1(|Globaltime|).Base

  • Hweeli's avatar
    Hweeli
    New Contributor III

    Hi,

    try T#YearPrior1(|Globaltime|).Base