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!
