'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]
After applying this i am not getting data populated in shipping time week line item
@Brj73
You're on the right track, you're formula is correct, but you may have overthought the formula. Take a look at YEARVALUE function. This is a better function since its basically a LOOKUP on the time hierarchy. make sure the TRA01 values are showing up.
YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)')
Thanks i got it
I had not applied formula in TRO1 shipping metrics by week so it was empty and not populated
Hi I used the function you provided but it is not working for me because of 'level mismatch on common dimension'.
If you missed our January 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”,…
Anaplan's next quarterly platform release webinar will be held January 29, 2026 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of…