Initially, I was using 'OFFSET(PO Submitted, -Shipping Time Weeks, 0)' as my formula for the Confirmed PO Delivery line item. This worked well until I got further along in the training and was required to add the ability to override shipping method to the module. I added the necessary line items and updated my formula to 'OFFSET(PO Submitted, -Final Shipping Time Weeks, 0),' but after doing this, the Confirmed PO Delivery and Confirm Purchase Order Receipt line items return 0 for all weeks. What changes do I need to make to my formula to offset based on the Finial Shipping Time Weeks line item?
... View more