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

June 2026 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our June 2026 official release notes. There you'll find information on: User Experience On-the-fly chart creation CoModeler Optimizer Integration with Workflow Extended runtime Forecaster Workflow Workflow builder undo and redo Batch submission and approvals…
Multi-factor authentication (MFA) for basic authentication
We’ve added multi-factor authentication (MFA) to basic authentication to further protect against automated and malicious login attempts. Customers with this feature turned on and using basic authentication will be required to authenticate with an authenticator application in addition to their password to access their…