INV01 - Shipping Time Weeks

Hi,

I am trying to add a formula for Shipping Time weeks in the INV01. I have tried these formulas but they don't work:

'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS07 Distribution Center Details'.Default Shipping]

Please guide me...

Mark

Comments

muizzsk9890

Hi @Markcol

I think you must try the first formula and stick to it as it is correct one. Just check other factors like format of the line item or summary method or applies to or time settings. Try your experimental method and apply that formula. Let me know if it doesn't work and also share the blue print view if it doesn't work.

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…