nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Recording now available! October 28 platform release event
If you missed our October 28, 2026 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…
Register for our Oct 28 platform release webinar!
Anaplan's next quarterly platform release webinar will be held October 28, 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…