嗨团队,我有一些问题与公式,其right or wrong? i have noticed 3 issues in my model 1. For Beginning inventory my formula is IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory here in week 2 of beginning inventory, it's displaying the same beginning inventory as week 1 2. Reorder flag my formula OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0 it's not changing for week 6 because beginning inventory is the same for all weeks 3. shipping weeks my formula 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product] It's showing on 1 in place it should show 2 for roads can anyone help me where am going wrong! and is my formula right or wrong?
... 查看更多