Hi All,
Any suggestion for using the previous formula in a custom time scale?
Scenario: Using Previous of same line item in Custom Timescale
Module : Products as Dimension, Current Week and Future Weeks (Custom Timescale)
Line Items :
Planned Order
Purchased Order
Final Forecast
Inv Projection
Inv Projection line item logic should be- If current week then Planned Order + Purchase order - Final Forecast if not current week then Previous(Inv Projection)+ Planned Order + Purchase order - Final Forecast
Thanks & Best Regards,
Aish