Wrong summary result for larger number. Different result while data is sorted .

Copper Contributor

Dear Experts,
I had problem with these numbers.
The results is different when I do Summary. Sort Min to Max, get different result with sort Max to Min.

Try to SUM these number in 3 mode:
1. Originally (as is i sent to You)
2. Sorted Min to Max
3. Sorted Max to Min
It will get 3 different Summary result.
Thank You
=========

0.01
-0.02
0.03
-0.04
-0.04
-0.72
-45.99
45.99
-411.98
411.98
-1,204.75
-2,646.46
2,646.46
-3,205.62
3,205.62
-380,820.87
380,820.87
-393,787.86
393,787.86
-510,426.49
510,426.49
-4,030,133.06
4,031,337.81
-4,107,839.72
4,107,839.72
-4,524,218.18
4,524,218.18
28,208,757.89
31,190,280.60
55,926,467.62
-65,486,836.13
65,486,836.13
-1,331,230,834.93
-1,732,068,342,228.98
-1,732,068,342,228.98
1,732,068,342,228.98
1,732,068,342,228.98
2,834,316,898,276.00
139,336,006,516,999.00
-142,170,351,624,033.00
-142,170,351,624,033.00
142,170,351,624,033.00
309,546,269,054,500.00
-309,546,324,980,967.00
-364,792,031,809,799.00
364,793,363,040,634.00
-435,214,420,163,346.00
435,214,420,163,346.00
-435,214,485,650,182.00
435,214,485,650,182.00
461,898,851,849,010.00
-461,898,879,007,953.00
461,898,879,007,953.00
-461,898,883,039,291.00

1 Reply