Previous of Same Line Item in Customized Time Scale

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

anirudh

Hi Aish,

 

Do the following in the time scale system module and not in the list. For simplicity's sake, I'm explaining it as list properties

 

Go to the custom time scale list and create 4 properties:

1. Date - Date formatted property. This should be the first day of the week

Ex: Week Of 13th July 2020 should be 07/13/2020

 

2. Last Week Date - Another date formatted property. Formula:

Date - 7

Result will be 07/06/2020

 

3. Week Name - Text formatted. Convert Last Week Date to the name of the custom time scale.

Result will be Week Of 6th July, 2020

Note: This property should match the name or code of the custom time scale list

 

4. Previous Week - Format this with the custom time scale list. Formula:

FINDITEM(Custom Time Scale, Week Name)

 

Let me know if this works

 

Regards,

Anirudh