Math Calculations adds decimals

[troelsotte]

Hi,

I am new to the community, so apologies for not following customs. I have a simple math formula to calculate differences between two columns. The result of the calculation has several extra decimals added which makes it seems as though they don’t reconcile. The purpose of the exercise is to reconcile the two columns and more for xx million rows.

I’ve read that it’s an issue with Java double format, but I have yet to find a sustainable solution beyond rounding. Could anyone help me please?

/Troels

[ipazin]

Hello @troelsotte,

welcome to KNIME Community!

Talking about issue discussed in this topic?

Too many decimals after "Unique concatenate"

Hi all, In workflow 1 I created a variable with a Math Formula and rounded it to 2 decimals using the Round function. At the end of the workflow I export all data with a Table Writer. In workflow 2 I import all data with a Table Writer. I then rename the above variable to “v_Price (corrected)”. At this stage I do not explicitly use a Round function, because I already did that in workflow 1. Also, I can see that the variable actually has 2 decimal places for all rows. Now comes the problem: wh…

Br,
Ivan

[troelsotte]

Yes, that is the interesting read I’ve done. However, there’s no real solution to the use of GroupBy and Math calculation which results in random differences.

To be harsh, having to defend the choice of software to a client is not particularly easy, when the software can’t add and subtract properly.

[ipazin]

Hello @troelsotte,

I get your point but can’t rounding help?

Br,
Ivan