Level 2 Sprint 3 - Safety Stock Flag Count

roblund
Occasional Contributor

Level 2 Sprint 3 - Safety Stock Flag Count

Season's greetings all.

 

I don't know why I am wrestling with this formula as it seems straight forward but it does not appear to be working correctly.  My line item formula is as follows;

 

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

 

Is there a logic context error here somewhere that I am overlooking?  Any help would be greatly appreciated. Thank you.

3 REPLIES 3
riyazpasha
Contributor

Re: Level 2 Sprint 3 - Safety Stock Flag Count

HI @roblund,

 

I think the line item is present in the INV02 Country Summary as Safety Stock flag count - Formula 'INV01 Inventory Ordering'.Safety Stock exception count[SUM: 'SYS08 SKU Details'.Country Made In].

 

The formula is exact. Check with the format. Also if you can attaché the error that you are encountering that would help us to find the exact issue. Also please check the line items names that should match in the formula(Capital letters, small letters or spelling check) 

ChrisHeathcote
Community Boss

Re: Level 2 Sprint 3 - Safety Stock Flag Count

@roblund 

Without seeing the error message it is challenging to give you an exact answer.

However, check through the following;

 

  • Is the dimensions of the mapping module the same as the source module, INV01? From your query this should be the list, SKU Details.
  • is the dimension of the target module the same as the line item in your mapping? From your query this appears to be, Country.

The above checks form the key bridge in connecting the source dimensions with those in the target. Without them the SUM functions will simply not work. If this is the case you should receive a mismatch of dimensions error.

 

  • Are you clicking through each element of the formula rather than writing in out? Differences in spelling and the absence of apostrophes ( ' ) for non numerical characters can cause errors. From your query I do not believe this is the issue.

Here is a link to the SUM section of Anapedia - https://help.anaplan.com/27935be6-48ba-47a2-bdd6-117d225e1b02-SUM 

 

Chris 

 

roblund
Occasional Contributor

Re: Level 2 Sprint 3 - Safety Stock Flag Count

Thank you. Figured it out weeks ago but I do appreciate you checking in