Sprint 3

Hi Members ,

Tried creating the below mentioned requirement with the formula written below , but not getting it correct .

Line Item Format Purpose

Safety Stock Flag Count

Number

Identify number of Stock Exceptions by Country and Product Family

IF 'INV01 Inventory Ordering'.Safety Stock Exception Count =1 THEN [SUM: 'SYS08 SKU Details'.Product Family,SUM: 'SYS06 Location Details'.Country] ELSE 0

Can you help ? I still have not received a correct answer to it .

Thanks

Comments

Misbah

@BapinB

No need to write IF ELSE statement

Formula should be like 'INV01 Inventory Ordering'.Safety Stock Exception Count [SUM: 'SYS08 SKU Details'.Product Family,SUM: 'SYS06 Location Details'.Country]

Remove Product Family aggregation from the formula and Finally check if the name of the line item is just Country or Country Made In

Misbah

Miz Logix

BapinB

Hi Misbah ,

Getting this error message when applying the formula

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS06 Location Details'.Country]

Screenshot_of_sprint_3_Q__150812.png

Misbah

@BapinB

Check the dimensionality of your target module - it should be P1 Product Family and G2 Country

Check the Dimensionality of Source Module, it should be P3 SKU

Check the Summary settings of Safety Stock Exception Count, it has to be SUM

Check the format of SYS06 Location Details. Country, it has to be formatted on G2 Country and the dimension of this module should be P3 SKU.

If all above are right then the below formula will work.

BapinB

Its formatted to G2 Country but P3SKU is not required in SYS06 . Its in SYS08

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…