Level 2 Sprint 3 TRA01 module creation

Hi - I am facing issues when trying to create the TRA01 module. I am getting zeros when I am trying to map the weekly values:

TRA01 module - formula

Shipping Time = WEEKVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)')

Cost per 1000 Units = WEEKVALUE('DAT02 Shipping Metrics'.'Cost per 1000 Units')

Results

Please help me understand what I am doing wrong

Sunil

Comments

Misbah

@sunilramakumar

Why are using WEEKVALUE function? You are trying to pull the Weekly values from source module which is at Year Level.

Hint: Try Using LOOKUP instead

Hope that helps

Misbah

[Deleted User]

ThIs this the logic ?
-Data Source is ----> DATA02 Shipping metrics : P2 Products , shipping methods, time ( year)
-Mapping--> Beginning Inventory P3 SKU , G3 location
-Data Target is ---> TRA01 Shipping Metrics by Week: P2 Products, Shipping methods Time (week)

Thanks
G.

kathleenseiler

Hi @sunilramakumar ,

You are using the WEEKVALUE() function, but trying to grab data from a yearly formatted module. What you really want is the YEARVALUE() function, so it will pull the yearly value into the week you are looking at in your target module.

Kathleen

jadefortunato

Having run into this myself I think the confusion is that "YEARVALUE" sounds like it results a total year value as an output, not that it takes a year value as an input (and and converts it for use in the new timescale). Likewise, "WEEKVALUE" sounds like it should produce a weekly output, not use a weekly input.

That's why we were (or at least I was) picking WEEKVALUE... it sounds like it produces weekly values.

JorgeGM

So would the formulas for this exercise respectively be:

YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)')

YEARVALUE('DAT02 Shipping Metrics'.'Cost per 1000 Units')

????????

Quick Links

Recent release news

June 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our June 2025 official release notes. The information below offers supplemental information to that post. Security and administration New 'Application Owner' security role Tenant administrations can assign the Application Owner role to users in their tenant.…
Register for our July 30 platform release webinar!
Anaplan's next quarterly platform release webinar will be held July 30, 2025 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 new…