Sys: Time Module Formula

Options
lkrylov
lkrylov Member, ALL USERS Posts: 2 New Contributor
in Planning & Modeling

Trying to understand what is wrong with this formula and why it doesn't give me 2019-2022. Instead, I only get 3 years, 2020-2022. If I change the formula to Prior Year -2 I get 2021-2022. Would appreciate any ideas. 

 

lkrylov_0-1609533069593.png

 

lkrylov_1-1609533113335.png

 

Tagged:

Comments

  • lkrylov
    lkrylov Member, ALL USERS Posts: 2 New Contributor

    Thank you for the incredibly quick response Jared!

     

    I tested some other options and found that this formula works. 

     

    PERIOD(START()) <= Current Year + 1

     

    Thanks for the tip on the Months. I realized that I had to also change the Summary to be Formula, Time: Any

Categories