Final Shipping cost

Options
FPAnalyst
FPAnalyst Member, ALL USERS, Partner Posts: 4 New Contributor
in Anaplan Community

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

 

Tagged:

Comments

  • NISHI
    NISHI Member, ALL USERS Posts: 5 Occasional 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

  • NISHI
    NISHI Member, ALL USERS Posts: 5 Occasional 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.

Categories