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

February 2026 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our February 2026 official release notes. There you'll find information on: User Experience Board Insights Panel Management Reporting on mobile Custom action buttons on mobile Modeling experience Four digit calendar Forecaster Holiday calendars UX pages…
January 2026 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our January 2026 official release notes. The information below offers supplemental information to that post. Dataspaces in Anaplan Data Orchestrator Dataspaces are partitioned areas of a tenant-wide Anaplan Data Orchestrator instance. Integration…