Level 2 Sprint 3 Question 3

Options
CommunityMember120326
CommunityMember120326 Member, ALL USERS Posts: 5 New Contributor
in Anaplan Community

Any idea why below formula is wrong for this question?

 

POST(Final Shipment Amount, Final Shipping Time Weeks)

Tagged:

Comments

  • VirajLTI
    VirajLTI Member, ALL USERS, Partner Posts: 1 New Contributor

    @JaredDolich 

     

    I think the formula for the Final Shipping Time Weeks should be:

     

    'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: Final Shipping Method, LOOKUP: 'SYS08 SKU Details'.Product]

     

    Correct me if I am wrong. But I thought that the formula needs modification since the question tells us to reference the Final Shipping Method line item.

  • KathyKayCoke
    KathyKayCoke Member, ALL USERS Posts: 1 New Contributor

    I tried using the formula IF Confirmed PO Delivery = 0 THEN 0 ELSE POST(Final Shipment Amount, Final Shipping Time Weeks) and it wasn't accepted.

     

    In fact none of my formulas are being accepted and it's very odd and this is my 3rd/4th answer, so I feel like one of the answers is correct.

Categories