Hello,
For the Shipping time Weeks following the instructions I used the formula but doesn't get me the correct value :
'TRA01 Shipping Metrics by Week'.'Shipping Time(Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product]
any suugestions?
Hi @Sangya,
I would suggest following approach, first compare dimensions between two modules
TRA01 Shipping Metrics by Week: Time, P2 Products, Shipping Methods
INV01 Inventory Ordering: Time, P3 SKU
Both modules are on weekly level, therefore that goes directly.
You correctly used LOOKUP: 'SYS08 SKU Details'.Product to go from P3 SKU to P2 Products.
However you are still missing something, try to compare modules and figure out what is missing in your formula.
Let me know if you have additional questions, I will try to help!
For calculating shipping time weeks ,i guess you need to use DATA02 Shipping metrics module where the data was imported.
Try using YEARVALUE function to pull the data from DATA02 module to target module.
Hope this helps
~Abhi
Thank You @abhi1017 . Will it be ok for you to share your email and may be I could reach out if I have any issue wrt to model building?
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…
