Level 2 3.4.3 Activity: Create Country Summary Module

LucaB

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

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. 😀