01-26-2024 07:28 PM
I would like the use one of the T#Global function and create a dynamic time list for the last 24 months. For example, I had the time as 2023M12, the list would show me all the months of 2023 and 2022. Anyone has any tips on how this can be acoomplished?
Trung
Solved! Go to Solution.
01-29-2024 06:10 AM - edited 01-29-2024 06:10 AM
T#YearPrior1(|GlobalTime|)Period(|GlobalTime|).Prior11, T#Global.Prior12, T#Global
Let's examine it from the end. T#Global will be our current Global period, easy. Then we add the previous 12 periods with .Prior12. That gives us 13 months, so we want the previous 11; to do that, we "rollback" to the same period (e.g. Dec) in the previous year, with T#YearPrior1(|GlobalTime|)Period(|GlobalTime|), and we use that as a reference to get the previous 11 periods.
This will give you the previous 24 periods inclusive.
01-29-2024 06:10 AM - edited 01-29-2024 06:10 AM
T#YearPrior1(|GlobalTime|)Period(|GlobalTime|).Prior11, T#Global.Prior12, T#Global
Let's examine it from the end. T#Global will be our current Global period, easy. Then we add the previous 12 periods with .Prior12. That gives us 13 months, so we want the previous 11; to do that, we "rollback" to the same period (e.g. Dec) in the previous year, with T#YearPrior1(|GlobalTime|)Period(|GlobalTime|), and we use that as a reference to get the previous 11 periods.
This will give you the previous 24 periods inclusive.
01-29-2024 01:54 PM
Jack,
You are a rockstar. Thanks for the explanation. I was able to take it a step further and added an extra year!
T#YearPrior2(|GlobalTime|)Period(|GlobalTime|).Prior11,T#YearPrior1(|GlobalTime|)Period(|GlobalTime|).Prior11, T#Global.Prior12, T#Global
The beauty of this is now this is always dynamic and I never have to maintain it.
Trung
02-07-2024 08:12 AM
The above thread is very userful.
I have another requirement. I want to build a data buffer to include data records of an account and all the periods ( M1 to M12) of the POV year dynamically ? thanks in advance.