3.4.3 Activity: Create Country Summary Module

motorwaygn
edited November 2022 in Academy Discussions

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,

Comments

  • JaredDolich
    edited November 2022

    @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]

  • Enis
    edited November 2022
    Great reply