Level 2 - Sprint 3 - 3.4.3 Activity: Create Country Summary Module

ismaelmaclovio
Contributor

Level 2 - Sprint 3 - 3.4.3 Activity: Create Country Summary Module

Hello all,

I'm having trouble figuring out with this error that I'm getting. Can anyone help me out?

My formula is this:

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: Level 2 - Sprint 3 - 3.4.3 Activity: Create Country Summary Module

@ismaelmaclovio 

Gotcha. It wasn't clear what module this formula was in.

In that case your formula is correct. So  you have a syntax error and need to make sure these two line items are spelled the same way as in your formula:

  • Go to SYS08. Is the line item spelled "Country Made In"
  • Go to INV01. Is the line item spelled "Safety Stock Exception Count"?

Next Steps

  • If both are spelled the correctly, then use the editor to create your formula rather than using cut/paste. You might have a special character in there somewhere.
  • Last step is that we need to make sure the modules are using the right lists and your line items have the right formats and summaries.

Let's see if that helps.

You're close. Hang in there.


Jared Dolich

View solution in original post

4 REPLIES 4
JaredDolich
Moderator

Re: Level 2 - Sprint 3 - 3.4.3 Activity: Create Country Summary Module

@ismaelmaclovio 

Super, Super Close.

Your Equation:

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]

Correct Equation

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Supplied By]

Let's break it down.

  • When ever you use a SUM the SOURCE module must have list formatted line item that is also a list in your TARGET module. 
  • Since the list choices in the TARGET module are P2 Products and s G3 Location.Distribution Center we need one of those in the SOURCE
  • INV01 does not have that line item BUT there is a system module that relates the INV01 list to DC and that is in SYS08.
  • Supplied by has a line item formatted as s G3 Location.Distribution Center!

 


Jared Dolich
ismaelmaclovio
Contributor

Re: Level 2 - Sprint 3 - 3.4.3 Activity: Create Country Summary Module

@JaredDolich 

Thanks for your reply. I tried your equation and got this error message.

 

JaredDolich
Moderator

Re: Level 2 - Sprint 3 - 3.4.3 Activity: Create Country Summary Module

@ismaelmaclovio 

Gotcha. It wasn't clear what module this formula was in.

In that case your formula is correct. So  you have a syntax error and need to make sure these two line items are spelled the same way as in your formula:

  • Go to SYS08. Is the line item spelled "Country Made In"
  • Go to INV01. Is the line item spelled "Safety Stock Exception Count"?

Next Steps

  • If both are spelled the correctly, then use the editor to create your formula rather than using cut/paste. You might have a special character in there somewhere.
  • Last step is that we need to make sure the modules are using the right lists and your line items have the right formats and summaries.

Let's see if that helps.

You're close. Hang in there.


Jared Dolich

View solution in original post

ismaelmaclovio
Contributor

Re: Level 2 - Sprint 3 - 3.4.3 Activity: Create Country Summary Module

@JaredDolich
Thank you for the help. It turns out that I was missing line item "Country Made In." I added it and then put the formula and it worked!