Previous of Same Line Item in Customized Time Scale
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 :
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
You will run into circular reference issues. @anirudh 's solution will take you to the point where you can get the previous week. Next steps are using LOOKUP to get the data for previous week but when you use that in your final line item you may run into Circular reference issues. One way I can think of doing is to create a mapping between Custom Time Scale and Native Time Scale and take it from there.