Forum Discussion

trunning's avatar
trunning
New Contributor II
11 months ago

dynamic time period member list

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

Parameters
Reports
  • JackLacava's avatar
    JackLacava
    11 months ago

    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.

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    11 months ago

    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.

  • trunning's avatar
    trunning
    New Contributor II
    11 months ago

    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

  • BSK's avatar
    BSK
    New Contributor III
    11 months ago

    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.