sprint3

BapinB · October 2022

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

Misbah · October 2022

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 · October 2022

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 · October 2022

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

Misbah

Miz Logix

Welcome!