Setting specific time period in the calculation definition

[Former Member]

Dear community,

I would like to have a KF that shows me only the actuals of a certain period

e.g ACTUALSQTY(1st period of the year) up to ACTUALSQTY (current period -1).

Would that be possible ?

Thank you very much for your support

Best regards

Vasilis

[sourojit_pal · Accepted solution]

Hi Vasilis,

If you know the PeriodID of the first period of the year then you can use the following:

IF( PERIODID>= "2001" AND PERIODID<=$$PERIODIDCU$$-1, ACTUALSQTY,NULL)

Assuming that,

- the period ID of the first Period of your year is 2001

- You are storing NULL in your KF for any PeriodID outside this period

Hope this helps,

Regards,

Sourojit

[Former Member · Accepted solution]

Thank you Sourojit for your very helpful answer,

I understand that the current period -1 is written as $$PERIODIDCU$$-1

Would you please have the pleasure to tell me of how to define the first period (month of September) of my calendar year?

My year defined in the calendar starts on September and ends on August.

Thank you very much for your patience and time!

Best regards

Vasilis

[sourojit_pal · Accepted solution]

Hi Vasilis,

I am not sure if there is a way to set a pointer to the first period in a dynamic way.

However as a workaround, you can do the following:

- Check the Period ID of the First September (say X) in you planning horizon

- Set this period ID as the beginning period of your Rule ie PeriodID>=X And PeriodID<PeriodIDCU

- In your excel set your horizon in such a way that at any given period of time your Planning view will begin from September of one year and end in August of the next year. This will enable you to view all the sales history (Actuals Qty) till the period prior to current period. All the periods from Current period onward will not get populated.

Hope this helps,

Regards,

Sourojit

[Former Member · Accepted solution]

Thank you Sourojit,

That was clear!

Thank you for your time!

Best regards

Vasilis

[sourojit_pal · Accepted solution]

Thanks Vasilis