Hi All,
Please help me with the formula for Beginning Inventory
My formula is - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
I don't know why I am getting everything negative in Beginning Inventory
Also let me know If i am correct in using the correct formula for Confirmed PO Delivery
OFFSET(PO submitted, -Shipping Time Weeks, 0)
Regards,
Ankita
Solved!去解决方案。