AnsweredAssumed Answered

Using split and splat with integers ?

Question asked by ecausse on Feb 11, 2019
Latest reply on Feb 13, 2019 by breuber

Hi all,

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

Etienne

Outcomes