Hi!
I am struggling to complete the INV01 Module Line Item Formula Details. It seems like everything is working except for the "Confirmed PO Delivery" formula. Below is the formula I have and the result I get:
IF PO Submitted = 1 THEN OFFSET(PO Submitted, -Shipping Time Weeks, -1) ELSE 0
I've found similar questions in the community but no clear way to resolve this.
另外,我通常会包含“ 0”中的偏移公式中的“ -1”,但这不是问题。
Can someone help me resolve this? The goal is to have the 1 from "PO Submitted" be reflected in week 3 of "Confirmed PO Delivery"
Thanks in advance!
Solved!去Solution.
@Lkishko
That activity almost made me lose my head. There is an error in the instructions. I will be sending that to the Academy. But that's not why it drove me crazy. The instruction was pushing me to use a formula I didn't want to use because it's not right. Then later in the exercise, it turns out I was right.
Like@eriktwelvecg您需要探索以外的功能,但这是练习的后面。
现在,让我们看一下您正在使用的偏移公式,因此我们谈到了一些概念:
Please review theOFFSETfunction on Anapedia.
Looking at theConfirmed PO Deliveryin Week 1, the formula is basically saying:
So,
An additional point that will not affect your results but it is rather a Best Practice to improve the performance.
When using an IF statement, think of提早出口。Meaning if you can get the formula to end after the THEN clause without going to the ELSE clause for the majority of the time then you are saving processing time. The way to achieve this is to start the IF function with the scenario you believe will happen more often.
In your case, what will happen more often? the PO Submitted = 1 or =0? Will we placing an order more often than using the default inventory values?
Let me know if you still have other questions. This is a "fun" exercise.
@LkishkoI believe this is addressed in a subsequent step in L2 training, but I would explore the POST formula rather than OFFSET
@Lkishko
That activity almost made me lose my head. There is an error in the instructions. I will be sending that to the Academy. But that's not why it drove me crazy. The instruction was pushing me to use a formula I didn't want to use because it's not right. Then later in the exercise, it turns out I was right.
Like@eriktwelvecg您需要探索以外的功能,但这是练习的后面。
现在,让我们看一下您正在使用的偏移公式,因此我们谈到了一些概念:
Please review theOFFSETfunction on Anapedia.
Looking at theConfirmed PO Deliveryin Week 1, the formula is basically saying:
So,
An additional point that will not affect your results but it is rather a Best Practice to improve the performance.
When using an IF statement, think of提早出口。Meaning if you can get the formula to end after the THEN clause without going to the ELSE clause for the majority of the time then you are saving processing time. The way to achieve this is to start the IF function with the scenario you believe will happen more often.
In your case, what will happen more often? the PO Submitted = 1 or =0? Will we placing an order more often than using the default inventory values?
Let me know if you still have other questions. This is a "fun" exercise.
嗨@Lkishko,
偏移功能的问题是它在目标周期基础上工作
so as per requirement for week 2 po submitted is 1 and shipping time is 2 weeks thereby confirmed PO delivery should have been 1 for week 4 but here it is 0 as offset basically brings values from n periods in the past (in case of minus) for each line item , so basically for each week , offset brings value of PO delivery from no. of periods before , for week 4 you see shipping time weeks as 3 thus it will post value of week 1 i.e 0 in this case .
hence POST is an alternative here because it simply posts value n periods in the future
on using post it will simply shift value of week 2 to week 4
Hope it clears