Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with the total line of a straight table

I have a straight table with the following values:

   

ItemAmt 1Amt 2Amt 1 / Amt 2
96294807$3,900.00$3,900.00100.00%
96430727$3,100.00$3,100.00100.00%
97619437$2,025.00$2,025.00100.00%
97632520$16,472.25$16,472.25100.00%
97856686$4,698.83$4,698.83100.00%
97883743$25,500.00$25,500.00100.00%
97931228$1,549.00$1,549.00100.00%
98727147$2,800.00$2,761.37101.40%
98930769$8,675.00$8,675.00100.00%
99069215$1,550.41$1,550.41100.00%
99115920$10,757.55$10,757.55100.00%
99401222$6,175.80$6,175.80100.00%
99649625$6,000.00$5,100.00117.65%
99793600$7,500.00$7,500.00100.00%
99918585$2,400.00$2,374.45101.08%
99984962$5,000.00$5,000.00100.00%
99989595$2,249.26$2,249.26100.00%
100056927$3,100.00$3,100.00100.00%
100099708$4,908.60$4,908.60100.00%
100401083$4,833.69$4,833.69100.00%
100485813$5,500.00$5,490.95100.16%
100492542$4,532.26$4,532.26100.00%
100609823$3,000.00$3,000.00100.00%
Totals$136,227.65$135,254.42100.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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

3 Replies
Anonymous
Not applicable
Author

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

satishkurra
Specialist II
Specialist II

What is the number format your are setting for the last expression Amt1/Amt2?

Anonymous
Not applicable
Author

#,##0.00%