Any idea why below formula is wrong for this question?
POST(Final Shipment Amount, Final Shipping Time Weeks)
@CommunityMember120326
Correct Formula:
IF Confirmed PO Delivery = 0 THEN 0 ELSE POST(Final Shipment Amount, Final Shipping Time Weeks)
Your Formula
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]
@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.
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.
Anaplan's next quarterly platform release webinar will be held April 29, 2026 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of new…
Check out the latest Anaplan feature updates and enhancements in our March 2026 official release notes. There you'll find information on: Intelligence Anaplan CoModeler Anaplan Analyst Anaplan Agent Studio User Experience Data driven hierarchies with drag-and-drop Enable or disable comments Module-driven navigation actions…
