FPAnalyst
New Contributor

Final Shipping cost

Hi,

I have a question about the Final Shipping cost.

The figures match with the test of the shipping cost but the formula doesn't pass the exam.

I don't know what I did wrong.

Capture11.PNG

5 REPLIES5
Misbah
Moderator

@FPAnalyst

I think the name of your module is incorrect. You have suffixed it with word "Module". Just get rid of that and type

'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'

If that doesn't work try rearranging your formula - results will be same though. It is juts doing (A/B)*C vs (C/B)*A

Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

Either way your module name is incorrect.

Hope that helps

adamsjk
Occasional Contributor

Hello,

I have tried 3 different ways to enter in the formula, all seems correct final calculation, and the exam is telling me they are all wrong.

Other combinations I am given a dimension error. Is there anything else you can provide?

einas.ibrahim
Master Anaplanner/Community Boss

Hi@adamsjkand@FPAnalyst

The issue might not be your formula. If you are using Any Anaplan extension to help with writing the formulas (indentation, color coding, autocomplete) then the exam may reject your formula copy/paste.

Either remove the extension or just use a different browser to take the exam. That's what I did.

Also,@Misbahis right. Remove the word Module from all your module names.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
NISHI
New Contributor

Hi, i stuck at updating formulas for below:

The following formulas are not working correctly:

  • Line Item: Confirmed PO Delivery
    • Formula: OFFSET(PO Submitted, -Final Shipping Time Weeks, 0)
  • Line Item: Confirmed Purchase Order Receipt
    • Formula: IF Confirmed PO Delivery <>0 THEN OFFSET(Final Shipping Amount, -Final Shipping Time Weeks, 0) ELSE 0

NISHI_0-1646315504628.png

And it should match this:

NISHI_1-1646315591860.png

I have been struggling since long time on this.

NISHI
New Contributor

Hi

How did you updated the formulas for this session (3 3 6 activity test the shipping cost formulas). please can you help me out to update the formulas to get the matching figures.

Thanks