About aishabhy05

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 ... View more

Good Day!!   I have a scenario where I'm trying to calculate the moving average from actuals in Custom Day time scale. In a module, I have sales data to be uploaded, from the sales data I have to calculate the moving avg of 90 days at the day level. Dimension in the module Article, Custom Day scale. Line Item -Sales  Qty, Sales Value.   I tried using the formula - Line item 1- CUMULATE(Sales Qty, FALSE, Custom Day)) / 90 Line Item 2- 'Line Item 1' - 'Line Item 1'[LOOKUP: Custom Day.'Current Day-90']   The Above formula gives average but not moving average. Any suggestions, please?     Thanks.   ... View more

Hi All,    I have a module with customised timescale. In Module A, dimensioned 24 Week Custom Timescale. In Module B with no dimension, I would like to get Sum of 12 Weeks from Module A. Any leads, please?    Thanks. ... View more

Hi,   I have a scenario where I have to take a snapshot every week(forecast periods) -max 6 weeks forecast period.     Source Module -Standard Time Scale, Article List, LineItem(which I want to take a snapshot)  Target Module- Standard Time Scale, Weekly snapshot LIST(Contains list member of Lag 1, Lag 2, Lag3..6), Article List, LineItem(Where the snaps will be stored)   Every week when I run the Action to capture the current week data it has to be in lag 1 always. Lag 1 data should be moving.    Instance, this week when I'm running the action to copy the data to fixed list member of lag 1. I want the previous week data to be moved to other lags.    Current Week - Lag 0 (Fixed) Previous Week- Lag1 A week before Data-Lag2    I want help on how to move the data from one lag to other lag (Lag is a list member). ... View more