Gruop By Mean does not match with Mean in Excel
Hello,
I am trying to migrate an excel base to knime using famous nodes (Joiner, Group By, Pivoting) and it is working. But when I downloaded the base from Knime to check the values, I figured out that the Mean calculated using Group By does not match with the simple mean from the Excel. See example attached:
In Excel the mean is zero. But using Group By from Knime the mean is 2,54426109809932E-17.
I believe it is a format issue, but I don’t know how to configure at knime. I need the same number from excel.
Could you help me please?
Thanks