bilbrandon
3 years agoNew Contributor III
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