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

 

nathan_rudman

you need to code you fake time over real time and do previous there.

 

I explained it in this post:

https://community.anaplan.com/t5/Anaplan-Platform/Trick-Previous-on-regular-list-sequential-calcs-using-time-as/m-p/64483

aishabhy05

@Ani , this works to get the previous week, but I would like to get the calculated line item previous weeks data

Misbah

@aishabhy05 

 

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.

aishabhy05

@Misbah  you are mentioning to convert to native timescale and use the previous function? 

aishabhy05

Thanks @nathan this helps.