Actual Years Boolean in Time Filter Module
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?
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
Hope this helps!
I knew it had to be something simple. Didn't know I could work with Time as a list-item-like thing. Thank you!0