Line Item Formula for Stock Expectations

neg177
neg177
in Modeling

Hi,

 

I used the following formula and it says the dimensions do not match. 

 

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS07 Distribution Center Details'.Country]

 

After that I used the the following formula to have the dimension of P2, and still not correct

 

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS07 Distribution Center Details'.Country, 'SYS04 Product Details'.Product Family ]

 

Please advice

 

Tagged:

Best Answer

  • Misbah
    Misbah
    Answer ✓

    @neg177 

     

    When you use SUM: you have to have those mappings as dimensions in your target module. If you want to aggregate Exception count by Products and DCs then Product and DC has to be the dimension of your target module and write the formula as:

     

    'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Product, SUM: 'SYS08 SKU Details'.Distribution Center]

     

    Misbah

Answers

Categories