3.4.3 Activity: Create Country Summary Module

motorwaygn
New Contributor

3.4.3 Activity: Create Country Summary Module

Hello,

 

This is my proposed formula for the Flag Count line item - taking into account the mapping for both country and product family that are dimensions in the INV02 module

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In, SUM: 'SYS08 SKU Details'.Product Family]

 

When reviewing posts on how to correctly populate the Flag Count line item the proposed formulas exclude the Product Family mapping - please can someone explain why this is?

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

@motorwaygn 

Your instincts are correct! You can set up the formula this way if you want, from a calculation engine standpoint, it doesn't matter. Anaplan has a built in feature that if the lists are the same between the SOURCE and TARGET, you don't need to use the SUM function on that list, it's implied. So this formula will work too.

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]


Jared Dolich

View solution in original post

1 REPLY 1
JaredDolich
Moderator

@motorwaygn 

Your instincts are correct! You can set up the formula this way if you want, from a calculation engine standpoint, it doesn't matter. Anaplan has a built in feature that if the lists are the same between the SOURCE and TARGET, you don't need to use the SUM function on that list, it's implied. So this formula will work too.

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]


Jared Dolich