Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table with the following values:
Item | Amt 1 | Amt 2 | Amt 1 / Amt 2 |
96294807 | $3,900.00 | $3,900.00 | 100.00% |
96430727 | $3,100.00 | $3,100.00 | 100.00% |
97619437 | $2,025.00 | $2,025.00 | 100.00% |
97632520 | $16,472.25 | $16,472.25 | 100.00% |
97856686 | $4,698.83 | $4,698.83 | 100.00% |
97883743 | $25,500.00 | $25,500.00 | 100.00% |
97931228 | $1,549.00 | $1,549.00 | 100.00% |
98727147 | $2,800.00 | $2,761.37 | 101.40% |
98930769 | $8,675.00 | $8,675.00 | 100.00% |
99069215 | $1,550.41 | $1,550.41 | 100.00% |
99115920 | $10,757.55 | $10,757.55 | 100.00% |
99401222 | $6,175.80 | $6,175.80 | 100.00% |
99649625 | $6,000.00 | $5,100.00 | 117.65% |
99793600 | $7,500.00 | $7,500.00 | 100.00% |
99918585 | $2,400.00 | $2,374.45 | 101.08% |
99984962 | $5,000.00 | $5,000.00 | 100.00% |
99989595 | $2,249.26 | $2,249.26 | 100.00% |
100056927 | $3,100.00 | $3,100.00 | 100.00% |
100099708 | $4,908.60 | $4,908.60 | 100.00% |
100401083 | $4,833.69 | $4,833.69 | 100.00% |
100485813 | $5,500.00 | $5,490.95 | 100.16% |
100492542 | $4,532.26 | $4,532.26 | 100.00% |
100609823 | $3,000.00 | $3,000.00 | 100.00% |
Totals | $136,227.65 | $135,254.42 | 100.74% |
The problem is that 136,227.65 / 135,254.42 should equal 100.72% not 100.74%.
What am I doing wrong?
Thanks,
Diane Smith
I figured out my problem. Sum(Distinct was not working as it was supposed to because of some bad data in the data model.
Thanks,
Diane
I figured out my problem. Sum(Distinct was not working as it was supposed to because of some bad data in the data model.
Thanks,
Diane
What is the number format your are setting for the last expression Amt1/Amt2?
#,##0.00%