IF THEN statement with Time Dimension
I have a module dimensioned by Employee Roster and Time. In it I have a line item 'Train/Predict'. In this line item I want to add a formula such that if it's a past time period then Train and for future time period = predict. I tied using the following formula - IF ITEM(TIME) <= Current Month? THEN Train ELSE Predict, but that throws an error that data type mismatch and it should be 'BOOLEAN'
Additional Information about the setup:
- I have a Train/Predict List item which is the data type for the line item Train/Predict
- Current Month? is in systems settings and the formula is a boolean line item that ticks of only the current month
Can you please help in how I can reference Time line item in the formula for Train/Predict?