sprint3

BapinB
BapinB
in Academy Discussions

Dear Members , 

 

Have used the below formula for 

3.3.5.2B Shipping Line Item

  • Shipping Time Weeks: Show the shipping time associated with the shipping method.

 

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

 

Not able to get the correct answer . 

 

Thanks 

Comments

  • Misbah
    Misbah

    @BapinB '

     

    You are missing an additional LOOKUP on Shipping Method. There will be two LOOKUPs but you have just used one

     

    Thanks,

    Misbah

    Miz Logix

  • BapinB
    BapinB
    Hi Misbah , 
     
    Used the below formula , But Nothing much happened ....
     
    'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: Shipping Method, LOOKUP: 'SYS08 SKU Details'.Product Family]
  • Misbah
    Misbah

    @BapinB 

    Now you have used LOOKUP on Product Family. It has to be on Products and Shipping Methods.

     

    Misbah

    Miz Logix

Categories