About sara.sa

Hi,   Thanks for your answer.   I'm trying to set the formulas for Line Items: Confirmed PO Delivery Confirm Purchase Order Receipt    - Line Item 'PO Submitted' is a simple formula to the boolean line item 'Submit Purchase Order Request': IF Submit Purchase Order Request THEN 1 ELSE 0 Thats ok for me   -Line Item 'Confirmed PO Delivery' This one is my struggle because I wanna check if Line Item 'PO Submitted' is > 0 and use the number of weeks to OFFSET it. Then my formula would be: IF PO Submitted > 0 THEN OFFSET(PO Submitted, Shipping Time Weeks, -1) ELSE 0   But this doens't look right and is not working as I want to.   And   -Confirm Purchase Order Receipt: IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, Shipping Time Weeks, 0) ELSE 0   I have some doubts here because I want to see the value of line item 'Suggested Order Amount for the Month' from week 1 on line item 'Confirm Purchase Order Receipt' at week 3, right? And with those formulas I have the value from week 3 in week 1, it's the opposite   Thanks again. Sara ... View more

Hi All,   I'm facing the same problem but I still couldn't get the solution.   I understand the logic of OFFSET function. But I'm not following what's the correct way to use it so my value from Week 1 appears on Week3   I made some tryings   IF PO Submitted > 0 THEN OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, -1) ELSE 0   IF PO Submitted > 0 THEN OFFSET(PO Submitted, -Shipping Time Weeks, -1) ELSE 0   IF PO Submitted > 0 THEN OFFSET(PO Submitted, Shipping Time Weeks, -1) ELSE 0   But none of them seems to make sense for what I need.   Thanks already.   Sara ... View more