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

[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')

????????