L2 Sprint 3 INV01 3.3.5.3

pjc95

All of the formulas seem correct but I cannot get Shipping Time Weeks to populate. Where am I making a mistake?

 

 

 

muizzsk9890

Hi @pjc95 

I will suggest you to check your summary settings for shipping time weeks. Try changing it to none.

Hope it helps!!

 

Regards,

 

Saket2022

Hi,

 

We are not able to see the complete formula in the screenshot.

Did you apply LOOKUP for both Product and Shipping Method? If you have applied only for product, the answer won't get populated.

pjc95

changed it to none and still nothing

pjc95

'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] is my full formula for Shipping Time Weeks

Saket2022

The formula is correct. I have the exact same formula and I am getting the correct values. The reason for not getting the answer in your case is something else.

muizzsk9890

@pjc95 @Saket2022 

Is there a possibility that there might be a minor change in formula for TRA01 &/or the LOOKUP line items which might be not showing up the values in INV01 ? Need to do some reverse engg for formulas on this. 

Please let me know if any one has got it through!!

 

Regards,

 

Saket2022

Please share your TRA01 module screen and SYS08 module screen. May be there is an issue in one of those modules?

@pjc95 @muizzsk9890 

pjc95

Saket2022

The blue print view is exactly the same as mine. Did you find where the mistake was? If not, can you also share the regular view of TRA01 and SYS08?

pjc95

Figured it all out! My shipping costs formula had switched order of operations.

RobJBurns

Referencing the most recent screenshots posted, in the SYS08 Module, what is needed in order for the Supplied By column to be populated. I'm thinking that I missed a step in the exercise but the lack of that data is causing the Shipping Method and Time to be nulled out in my INV01 model.

Unknown

This content has been removed.