Level 2 - 3.3.5.2B Shipping Line Items : check your work

LucaB

Hello,

In the Level2 Sprint 3, I completed the 3.3.5.2B Shipping Line Items exercise, however when checking the content in the module the figures are not correct, despite I'm quite confident the formulas should be correct..

I run the process 9 as reported in the hints, I did not get any errors..

unless I missed something (that could be…) the module TRA01 Shipping metrics by week is empty but after creating it, I did not find any steps to populate it.

Any suggestions?

Thanks

Luca

Prajjwal88

Hi @LucaB ,
You must have imported the data for shipping metrics in a data module at Year level (likely DAT02 Shipping Metrics).

From there, you’ll need to bring those values into the weekly module (TRA01 Shipping Metrics by Week) using the YEARVALUE() function. This will map the yearly values down to the weekly level. You can use a similar formula to pull in values like Cost per 1000 Units Line Item as well.

Hope this helps. 😀