I got a circular reference for the below action.
- Redirect the formula for this line item that currently references the Suggested Order Amount for the Month line item to the Final Shipment Amount line item instead.)
This is the original formula for Confirmed Purchase Order Receipt
IF
Confirmed PO Delivery > 0
THEN
OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0)
ELSE
0
Since final shipment amount is a function of starting function - demand + confirmed purchase order receipt. I do not understand how could we replace this offset with final shipment amount.
Here are the formula for other calculations
Thank you.