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

September 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our September 2025 official release notes. The information below offers supplemental information to that post. Planning experience Improved Keyboard navigation across cards Across Boards, Insights, and Worksheets, tab navigation through toolbars in cards and…
Register for our October 29 platform release webinar!
Anaplan's next quarterly platform release webinar will be held October 29, 2025 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…