Line Item Formula for Stock Expectations

Highlighted
Frequent Contributor

Line Item Formula for Stock Expectations

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

 

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Line Item Formula for Stock Expectations

@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

Highlighted
Frequent Contributor

Re: Line Item Formula for Stock Expectations

I understand. Thank you for your help.