Showing results for 
Search instead for 
Did you mean: 

Weighted avg for min/max inv targets aggregated at product level

We are implementing IBP IO and have a requirement to take the weighted average for min and max inventory targets, which are at a PERPRODLOC level, and assigning this weighted average to the min/max at the aggregated PERPROD level. I was wondering how this can be done in IBP. The business does not have a file providing the weights but would like this calculation to be done for these key figures in IBP. Is there a way for IBP to reference the key figure quantities and assign the weights based on the inventory in those product-locations? Does anyone know the best approach to assign this weighted average at an aggregated product level?

Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos

Hi Melanie,

Kindly let us know if you were able to accomplish this requirement.



Answers (0)