Level 2 Sprint 3 TRA01 module creation

sunilramakumar
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

 

1 ACCEPTED SOLUTION

Accepted Solutions
kathleenseiler
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

View solution in original post

3 REPLIES 3
Misbah
Moderator

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

gfraotero
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.
kathleenseiler
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

View solution in original post