Value dropping when applying percentage split

[TabsheerMohamed3]

Hello Alteryx community,
I’m facing an issue when distributing values using percentages, and I’m hoping someone can provide insights or solutions.

In my workflow, I have an initial amount (e.g., $1000) assigned to each order and a percentage field that I use to split this amount across different fleets. The total allocation across divisions correctly sums to $1000, so no value is lost at that level. However, when I attempt to distribute the amount at the order level based on percentages, the sum of the newly calculated values drops by 10-15%. Instead of maintaining the original $1000, it now totals around $850.

I suspect the issue might be occurring during the percentage-based distribution, but I’m unsure what’s causing the discrepancy. Has anyone encountered a similar issue, or does anyone have suggestions on how to resolve this?

Any guidance would be greatly appreciated!

Thanks in advance!

[alexnajm]

I would check your values at each stage to see where the drop off occurs - you can put down Browse tools too the help get quick sums of your columns

[TabsheerMohamed3]

Thank you for your response, I have tried multiple validation but nothing seems to work.

[alexnajm]

We can't help further then without seeing something!