Actual Years Boolean in Time Filter Module

mercerjt
mercerjt
in Modeling

I'm sure I'm just overlooking something simple, but I'm hoping to get a quick answer out of the community.

I have a global Time Settings module with the current period in it (Current Month line item and Current Year line item).

In a Time Filters module, I have a boolean for Actual Months (all months preceding Current Month). I want to add an Actual Years boolean as well, but for the life of me I can't get the boolean to ever result in True. Any quick answers here?

Tagged:

Best Answer

  • jasonblinn
    jasonblinn
    Answer ✓

    @mercerjt 

     

    I have replicated this situation, and my current year is FY21.

     

    I have put a formula into a line item that is boolean formatted, and the Time scale is Year.

     

    My Formula is: ITEM(Time) < Time Settings.Current Year

     

    jasonblinn_0-1613456325020.png

     

    Hope this helps!

    Jason

     

Answers

  • mercerjt
    mercerjt

    I knew it had to be something simple. Didn't know I could work with Time as a list-item-like thing. Thank you!

Categories