Level 2 Sprint 3 TRA01 module creation

[sunilramakumar]

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

[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

[gfraotero]

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 · Accepted solution]

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

[jasonfortunato]

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.