Level 2 Sprint 3 TRA01 module creation

Highlighted
Contributor

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:

 

sunilramakumar_0-1589945681035.png

 

TRA01 module - formula

sunilramakumar_1-1589945722391.png

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

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

 

Results 

sunilramakumar_2-1589945826303.png

 

Please help me understand what I am doing wrong

 

Sunil

 

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: Level 2 Sprint 3 TRA01 module creation

@sunilramakumar 

 

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

Misbah_0-1589965698380.png

Hint: Try Using LOOKUP instead

 

Hope that helps

Misbah

Highlighted
New Contributor

Re: Level 2 Sprint 3 TRA01 module creation

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.
Highlighted
Certified Master Anaplanner

Re: Level 2 Sprint 3 TRA01 module creation

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