Level 2 3.4.3 Activity: Create Country Summary Module

LucaB · 2025-07-28T17:41:10+00:00

There was an error rendering this rich post.

Hi,

I completed this activity, however I have many doubts about the figures and that makes me think I could have done something wrong in the setup despite I thought my formulas should be correct..

I have doubts on these figures in the module INV02, the same figures over months.

I think my SYS08 SKU details module looks fine, the additional line item Country Made shows the right value

the module INV01 should be ok.

could someone point me in the right direction?

Many Thanks!
Luca

Accepted answers

Prajjwal88

Hi @LucaB ,

Could you please highlight the specific line items where you believe the values are incorrect? Based on the screenshots, I noticed that the line items related to Shipping Method and Shipping Costs appear blank. Since you’ve already applied the correct formulas, it could be a DCA (Dynamic Cell Access) issue; I’d recommend checking the Write Access Driver settings for those line items.

Also, regarding your concern about the figures in INV02 (specifically the Safety Stock Exception Count), note that this line item pulls data from INV01. If your current formula is:

IF Ending Inventory > Safety Stock Target THEN 0 ELSE 1

I suggest updating it to:

IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0

As based on your current formula if Ending Inventory and Safety Stock Target are equal then also it'll give result as 1, which could otherwise lead to an inflated exception count during aggregation.

Hope this helps. 😀

All comments

Prajjwal88

Also, regarding your concern about the figures in INV02 (specifically the Safety Stock Exception Count), note that this line item pulls data from INV01. If your current formula is:

IF Ending Inventory > Safety Stock Target THEN 0 ELSE 1

I suggest updating it to:

IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0

As based on your current formula if Ending Inventory and Safety Stock Target are equal then also it'll give result as 1, which could otherwise lead to an inflated exception count during aggregation.

Hope this helps. 😀

LucaB

Hi @Prajjwal88

many thanks for your prompt answer.

I reviewed my modules and followed your advise.

It looks good now, in case I might struggle with something I'll rise a questions.

Many thanks, really appreciate.

Luca

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…