3.3.5.6

Winter01

Have been trying the Shipping cost variance formula but could not crack it. Help?

Comments

BrunoRodriguez

Hello @Winter01 ,

Without having the purpose in front of me, I understand that this value:

Will only change in the case the Shipping method is changed.
- Hence you need to think that, as a boolean, there are two states for "Override Shipping Method?" either true or false
When it is not overridden, the value will have to be 0, as there will not be no variance. This seems to be the most frequent situation.
When overridden, it will be the difference between the original Shipping Costs and the newly calculated Final Shipping Costs.

I hope the lines above were clear enough. If you still have doubts do not hesitate to keep asking!

Abhishek90

Hello
Good day to you !
can you help me for the Shipping cost variance formula
Thanks

Abhishek90

IF NOT Override Shipping Method? THEN 0 ELSE Shipping Costs - Final Shipment Amount

this is the formula I am using.
can you please let me know if this is a correct formula or not

thanks

Yogitha

Is the above formula right?

I also applied this.

tabryant

IF NOT Override Shipping Method? THEN 0 ELSE Shipping Costs - Final Shipping Costs is the correct formula

Sagar17

Can anyone please help me with Shipping Costs formula in sprint 3 activity 3.3.5.6

Vamsi_Kaki

Hello @Sagar17 To calculate Shipping costs, we require Shipment amount, Shipment cost by shipping method by Product. Here the formula u can reference.

Final Shipment Amount * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 units'[LOOKUP: Shipping Method, LOOKUP: 'SYS08 SKU Details'.Product] / User Selections.Shipping Costs items count

Quick Links

Recent release news

August 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our August 2025 official release notes. The information below offers supplemental information to that post. Planning experience Multi-browser tab syncing When changing context or data on a UX page, you can now view real-time data updates across up to five…
July 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our July 2025 official release notes. The information below offers supplemental information to that post. Planning experience External URL navigation button Page builders can configure navigation action buttons to link to external URLs, including non-Anaplan…