Hello, I add a math formula between two double type variables in knime which gives me different result compared to usual calculator .
var1 :$fee_charges_charged_derived$
var2:$rate$
math formula var1* var2 which gives wrong multiplication
I want to know what is tis bug ??
Hi @Kanika_1234 , this looks to me like your data is not being displayed in full, and that to 3 decimal places, they “appear” to be the values 17465.254 and 0.048.
The default rendering is to 3 decimal places.
I can find values that put 847.041 and 830.75 within the range of possibilities for those two numbers, e.g:
To achieve the above, my actual data looks like this:
| High | 17465.254499999999999999 | 0.0484999 |
|---|---|---|
| Low | 17465.25354 | 0.0475 |
The same (or similar) results can be achieved in Excel, when rounding the output:
So, please check you underlying data, as this is most likely that what you are seeing is actually rounded.
If that isn’t the problem, please upload some sample data that exhibits the result you are seeing.
