Level 2 Sprint 3 INV02 Country Summary module

I've created the INV02 Country Summary module and when comparing the "Stock exception Review Dashboard" the numbers do not reconcile. it seems like the safety stock flag count is not counting at the Product family level or it is individually adding up the "1's" per week as opposed to per month. I've attached my view as well as the "review" view in the training.

The formula I'm currently using in the safety stock flag count is : 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]

I've tried adding a second "sum" referencing the Product family line item in the SYS08 SKU module as well, however the results are the same.

I would just like to confirm that we should be matching to the pictures provided within the modules & and if so can someone point me in the right direction as to what is causing this issue?

My_view_Inv02_Exceptions_by_country_79058.PNG

training_view_79058.PNG

Comments

filip.sypniewski

Hi @bleeds,

it seems that your formula is correct in INV02 module.

Therefore you should review:

- your source module - do you have all numbers aligned with screenshots provided for INV01 module? How are you calculating Safety stock exception count?

- SYS08 module, if your Country Made is correct

bleeds

Hey Appreciate the quick response:

My SYS08 Module Country made appears to be correct - 'SYS06 Location Details.Country[LOOKUP: Distribution Center] format is the G2 Country List.

I also went through and did a reasonableness check - the requisite Cities and countries line up correctly.

And yes my related to the INV01 screen shots/source information all appear to be correct as my product replenishment dashboard looks good.

Safety Stock exception count formula = IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0

Kanishq17

hi @bleeds

Can you show your safety stock exception formula? because formula is correct for both exception count and then INV02, aggregation by country

bleeds

Hello,

I was able to solve my issue...utilizing the "any" function.

Best,

Brian

madhurigovankop

hi @bleeds

I am facing the same issue as you in the INV02 Country Summary Module- Safety Stock Flag Count . The safety stock flag count is not counting at the Product family level ,it is individually adding up the "1's" per week as opposed to per month. Please could you explain how exactly did you use the ANY function so to match the Prototype data?

Thanks in advance for your help.

CarlosT

HI bleed I am having the same problem as you, can you please explain how you used the ANY function to match the values because I am getting the values for the Product family list?
thank you.

KhumoS

Hey,

This is the formula I used for the 'Country Made in' line item in SYS08: SYS06 Location Details'.Country[LOOKUP: Supplied By]
and then I used this formula in the INV02 saftey stock flag count line item : 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made in, SUM: 'SYS08 SKU Details'.Product Family]

Quick Links

Recent release news

September 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our September 2025 official release notes. The information below offers supplemental information to that post. Planning experience Improved Keyboard navigation across cards Across Boards, Insights, and Worksheets, tab navigation through toolbars in cards and…
Register for our October 29 platform release webinar!
Anaplan's next quarterly platform release webinar will be held October 29, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of…