L2 Sprint 3 INV01 3.3.5.3

pjc95
pjc95
in Academy Discussions

All of the formulas seem correct but I cannot get Shipping Time Weeks to populate. Where am I making a mistake?FireShot Capture 019 - - learning.anaplan.com.png

 

FireShot Capture 021 - Anaplan - Level 2 Supply Chain Philip Cramer - us1a.app.anaplan.com.png

 

FireShot Capture 020 - Anaplan - Level 2 Supply Chain Philip Cramer - us1a.app.anaplan.com.png

 

Comments

  • muizzsk9890
    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,

     

    Regards,

    Muizz S.

  • Saket2022
    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
    pjc95
    changed it to none and still nothing
  • pjc95
    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
    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
    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,

     

    Regards,

    Muizz S.

  • Saket2022
    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
    pjc95

    FireShot Capture 047 - Anaplan - Level 2 Supply Chain Philip Cramer - us1a.app.anaplan.com.pngFireShot Capture 048 - Anaplan - Level 2 Supply Chain Philip Cramer - us1a.app.anaplan.com.png

  • Saket2022
    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
    pjc95

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

  • RobJBurns
    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.

Categories