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
Go to Solution.
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
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.