Error in calculating sum of rows

Question

enter image description here

Can anyone please explain why this happen? If i get SQL sum its total correct. My code is below.

private void calTotalSMV() {

    double ttl_smv = 0;
    for (int x = 0; x < OBJ_CALLER.DTMEMERG.getRowCount(); x++) {
        ttl_smv += Double.parseDouble(OBJ_CALLER.DTMEMERG.getValueAt(x, 3).toString());
        System.out.println("total smv = " + ttl_smv);
    }
    jLabel23.setText("" + ttl_smv);
}

See StackOverflow Questions: Why do I see a double variable initialized to some value like 21.4 as 21.399999618530273? or
Retain precision with Doubles in java — Paul Samsotha, Oct 17 '13 at 06:06

score 0 · Answer 1 · answered Oct 18 '13 at 05:40

0

It is not an error, it's all about precision for floating point numbers(float, double).If you want more accurate results, use BigDecimal. Easier solutions would be rounding(Math.round function) and formatting(NumberFormat).

answered Oct 18 '13 at 05:40

Silviu Burcea

5,103
1
29
43

Error in calculating sum of rows

1 Answers1