DataEase blog

By deafult, DataEase rounds UP a calculated numeric field (which is set to 1dcp or more).

Therefore, if field X = a + b + c and fields a, b & c is of 2dcp or more with each having a derivation of 1/3, DataEase rounds the calculated value to 1 instead of 0.99 (recurcive, depending on the number of decimal places).

If you amend field X’s derivation to:

floor(a*100+0.5)/100 + floor(b*100+0.5)/100 + floor(c*100+0.5)/100

Field X will now display 0.99 (recurcive, depending on the number of decimal places it has been defined to).