Level 2 activity 3.3.5.2B formula for Shipping line items

Ok! The good news - your formula is perfect. Great job. Because, that's the most important thing is that you thought through the formula correctly. Your probably getting an invalid formula error because something is misspelled. Try using the mouse to select the line items from SYS07 and SYS08 instead of typing them in. Start the formula over from scratch. The only thing you should be typing is the brackets for the lookup function and the word LOOKUP: Oh! and make sure the Distribution Center line item is a LIST formatted line item from you list subset s G3 Location:Distribution Center?

You got this!

'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Distribution Center]

Thanks! the first question is sorted. but still struggle on #2

Now #2 I got data import with shipping time and cost but not yet sort out the formula.

Yep. TRA01 is formulaic, nothing to import. You'll get both from DAT02 but you need to obtain the yearly value so you'll use the YEARVALUE.

Thanks! It's done. Now not sure how formula work that I use

'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Distribution Center] but not sure how to reference to Shipping methods

Yep. When you want to "lookup" a value in Anaplan you have to tell Anaplan the intersection at the source, in this case the source is TRA01 and it uses the lists Shipping Method and P2 Products. So, if we want that value we have to supply BOTH of those list items (shipping method and P2 Products). In your formula you only provided one.

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

Thanks Jared!

I tried to apply same formula and return with error message?

3_149055.JPG

Misspelled? You may have spelled things differently than me. Use the mouse to select the line items. Make sure all LOOKUPs are using list formatted line items. You'll be fine!