Hello Everyone!

I hope you’re doing well!

I’m trying to distribute a volume in boxes to some stores. I calculated the sales percentage based on the product’s sales in each store using the formula Quantity in Cartons * Distribution Percentage - Sales percentage. However, this gives me a number with decimal places, and I can’t send half a box to a store, haha, lol!

Is there a way to handle this? If I use the round formula, it might round up or down, causing me to miss sending all the boxes I have.

Maybe using a loop would help, but I’m not sure how to go about it…

In the example below, the distribution is done manually, but I’m looking for a more automated formula or approach.

KNIME WORKFLOW BELOW

Distribute the volume into boxes without decimal places.knwf (7.8 KB)