Hi All,
I have tried 'ROUND' function in reportnet and I understand CRN uses even rounding.
But what I observed and do not understand is the strange way this works with negative numbers.
When the number is negative and the digit after the rounding digit is less than 5, CRN seems to subtract the rounding digit by 1.
For example for an input of -8.31, and round(number,0) the report shows -7. Whats even worse for -100.0, the rounding returns -99.
Am I doing something very wrong or is this the normal behavior with CRN?
Is there a work around for this?
I have tried 'ROUND' function in reportnet and I understand CRN uses even rounding.
But what I observed and do not understand is the strange way this works with negative numbers.
When the number is negative and the digit after the rounding digit is less than 5, CRN seems to subtract the rounding digit by 1.
For example for an input of -8.31, and round(number,0) the report shows -7. Whats even worse for -100.0, the rounding returns -99.
Am I doing something very wrong or is this the normal behavior with CRN?
Is there a work around for this?