If I calculate essentially the same column using [Amount_Open] / [Amount_Payed]
I get a difference of several %.
The actual code is a bit more complex as there is a some basic set analysis in the sums to filter out certain data rows. And the actual Amounth Due And payed is calculated from several fields as well. However It's the same in both expressions. I don't believe it's a rounding error as even rounding to 0.00000001 doesn't impact the result I get from the combined expression.
Re: Dividing 2 Expressions in a chart: A Different result for the 'same' calculation.
Thx for the reply.
Here's a cleaned up test table.
And by putting it in a smaller test table... I just noticed the expression for 'Payed' did not filter out the invalid records, but the expression for % payed did. My bad, will have to debug in small test tables more often .