INV 01 Shipping Time Week

Options
preetdhar80
preetdhar80 Member, ALL USERS Posts: 5 New Contributor
in Planning & Modeling

Hi I'm stuck with this formula for last 2 hours. Pls help clarify what is wrong with this?

 

INV01 Shipping Time Week - I'm getting "Format of mapping used for lookup doesn't match any dimension of the source"


'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product,LOOKUP: Shipping Method]

Tagged:

Comments

  • preetdhar80
    preetdhar80 Member, ALL USERS Posts: 5 New Contributor

    Hi, this is part of the Anaplan 3.3.5.2 > Shipping time weeks data calculation. Most solutions suggested on the community suggest the formula I had earlier shared but somehow it does not work.

    TRA01 has 
    P2 Products & Shipping Methods as pages.

    Shipping Time (weeks) and Cost per 1000 units as line items.

    Time in weeks.

     

    INV01 is attached.

  • preetdhar80
    preetdhar80 Member, ALL USERS Posts: 5 New Contributor

    Nutzo bar is the Product and Nutzo bar_EN is the SKU.

     

    I have also attached other two modules I' referencing to get the correct data. Somehow I think TRA01 has an issue, if you see the yearly number for shipping time is exorbitantly high.

  • preetdhar80
    preetdhar80 Member, ALL USERS Posts: 5 New Contributor
    I found the issue. In blueprint mode the 'Applies to' field was blank (instead of a '-' ) and that resulted to multiple incorrect calculations across modules.

    Anaplan is amazingly funny 🙂

Categories