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





Please help me understand what I am doing wrong





  • @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


  • 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)

  • 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.

  • So would the formulas for this exercise respectively be:

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

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