Level 2 Sprint 3 INV01 - Not 1st week of Timescale?
I have a question on the line item Not 1st week of Timescale? in the "SYS01 Time Settings By Week' module of Supply Chain Model. I am trying to understand the formula for First week of the timescale. Whatever i try to generate for this lineitem is based on the current period of the timescale. What i am trying to understand is that is there any logic which does not have to depend on the current period because that be can change anytime. Please also let me know if my understanding that the 1st week of Timescale should never change even though the current period changes. Please let me know if you need any other information.
Thank You for your help. I was just using a comparing using the ITEM function of time and Current Period which is not the way to do. Like you said, i need to have a universal formula and working on getting it. Thanks again for making me understand.
One of which is the Time and Date functions category. That's your first stop. The function you are seeking has to be related to Time/Date. You need to find a function that behaves differently - or returns a special output- in the first period of the time scale.
I'm sure you will get it once you review the calculation functions, but again, if you still have questions let me know.
P.S. We are supposed to help community members who are going through the Model Builder certificates by guiding them through the process rather than giving them the ready answer.
Thnak you for your insights, they are always helpful. Concerning this topic i have a question. I used the "NOT INPERIOD(CURRENTPERIODSTART())" formula and it's working. But i know that if we change the current period my formula doesn't not work anymore. I couldn't find a formula that targets the start of time scale and not the current period. Could you help me ?
Re: Level 2 Sprint 3 INV01 - Not 1st week of Timescale?
Hey @ Younes
I’ll be more than happy to help you. Can I ask you for a favor. Could you post the same question in the training forum -instead of Anaplan platform Forum- yah it with Model 2 training and mention me like you did here and will pick the Conversation there