3.4.3 Activity: Create Country Summary Module

Hi All,

I am stuck in this exercise almost 2 hour, not able to proceed further. Can anyone please help?

I have added line item "Country Made in" SYS08 SKU details module. Now i know that the formula in Safety stock flag count would be 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In] but to this formula work do i need to pull the data into Country Made in Line item in SYS08 module. If yes how? and from which module i can get this? trying it from 3 hour almost but dont see any progress. Appreciate your help.

Capture_133503.PNG

Comments

Sahitya

Hi @RaghuMulki

Your safety stock flag count formula is correct. To that formula to work correctly "country made in" line item needs to be populated which can be done through SYS06 Location details. You can use lookup to populate from SYS06 Location details' line item supplied by.

Hope this helps!

Cheers,

Sahitya

Ankur.Sonthalia

Hi @RaghuMulki
You have to populate the Country Made line item. Country is nothing but the parent of Distribution Center. So just use PARENT function to find country in that line item
Parent(distribution center)

RaghuMulki

Thanks for you help. Formula is worked for me.

MAwude2010

Thanks ever so much for the tip. I used the function ---PARENT(Distribution Center)---

This has been a lifeline. Thanks to all who have taken their time to support aspirants like me

Michael

jadefortunato

Hi,

I am trying this but mine refuses to populate. For reference, Supplied By is formatted as "Distribution Center?" and Country Made In is formatted as "G2 Country"

If I use PARENT(Supplied By) it accepts the formula but does nothing.

If I type in PARENT(Distribution Center?), since it won't allow me to select the column in the list, it throws an error.

What is going on here?

DanielleCampbell

I am struggling with the same thing, hence why I am on here. But you have an extra closing parenthesis ")" in your formula. Maybe that is why?

jadefortunato

I don't see an extra?

What was you question, maybe I can help.

Yogitha

Getting an error when using the formula.

2022-10-29 (7).png

tthornton

was this ever resolved? I'm struggling with the same question

devrathahuja

@tthornton - What issue are you facing exactly?

SKanaplanner123

Your error is because you are using " number" as the format

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…