Formula error
In my Stat forecast I have some items mentioned as "End of Life" and it has a date until which the item will be active for forecast but after that date it will go inactive. But the formula that I have now isn't giving me forecast for that item.
For e.g.- For Item A - EOL = Jan 2025. (so this should give forecast till Jan 2025)
But in current scenario, its not giving any forecast even if the EOL date is until 2025.
Not sure if my formula is correct or I am missing something.
0
Answers
-
You would need to leverage a time dimensioned module to drive the Boolean logic: EOL <= END()
The forecast condition flexes depending on which month you are attempting to forecast thus you can't define it as a flat module.
0
