I am currently facing a very delicate problem with a budget application I'm working on.
The objective of this app, in line with Board key features, is to use split and splat functionality and previous year data to provide a detailed budget file (by SKU, Sales Force and geography) that will then be uploaded to another system.
We met a big issue recently, which is the result of several factors:
- the target system expects integers for quantities, and Cost of Sales is recalculated from this rounded quantity
- in my Board app, I keep "floating" quantities to make split & splat easier, then I apply a rounding function at the very end of the process.
- In a specific company, we found out that the result of the simulation ended in too many quantities below 1. Therefore the rounding effects were much more significant than planned.
So I have a general question as I am sure I am not the only one with this issue : how do you manage your process when you want integer quantities as a result of a multi-dimensional split & splat process ?
Thanks for your contributions