Want help with this formula.
@Yogitha
You have to reference the line item from TRA01 Shipping Metrics module by looking up on Products and Shipping Methods.
Thanks,Misbah
Mix Logix
IS THE FORMULA RIGHT?
'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]
Other line item updates:
Confirmed PO Delivery and Confirmed Purchase Order Receipt:
Before you continue, review and update the Summary Method settings for the line items.
WHAT SHOULD I DO WITH THE ABOVE INSTRUCTIONS? I AM CONFUSED
In these two line items, you must have used Shipping Time Weeks before. Well, now you will have to replace Shipping Time Weeks with Final Shipping Time Weeks and that's it.
Thanks,
Misbah
Miz Logix
So for this also same thing I need to do?
Confirmed Purchase Order Receipt:
My formula for "CONFIRM PURCHASE ORDER RECEIPT"
IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0) ELSE 0
3.3.5.4 -
so should I replace Suggested order amount for the month with Final Shipment amount?
That's correct!
Check out the latest Anaplan feature updates and enhancements in our April 2026 official release notes. There you'll find information on: Polaris Trigonometry functions MOVINGSUM on general lists Line item limit Security and tenant administration CAPTCHA on basic authentication Anaplan XL (version 2604) Offline writeback…
If you missed our April 29, 2026 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…