Level 2 Sprint 3 Question 3

CommunityMember120326
New Contributor

Level 2 Sprint 3 Question 3

Any idea why below formula is wrong for this question?

 

POST(Final Shipment Amount, Final Shipping Time Weeks)

1 REPLY 1
JaredDolich
Moderator

Re: Level 2 Sprint 3 Question 3

@CommunityMember120326 

Correct Formula:

IF Confirmed PO Delivery = 0 THEN 0 ELSE POST(Final Shipment Amount, Final Shipping Time Weeks)

Your Formula

POST(Final Shipment Amount, Final Shipping Time Weeks)

 

So, your syntax is correct, which suggests that the formatting of the line items may not be. Make sure both are formatted as numbers.

Also, double check your Final Shipping Time Weeks formula:

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


Jared Dolich