Decimal Rounding

Hi, I must be missing something but I cannot get the result I expect with decimal rounding

Please see screenshots

Hi Bruce.

I spoke with developers about it.
This is a rather complicated issue.
I believe we use bankers rounding for 'Nearest' rounding and not mathematical.
Which one is better is a good question...
Anyway we are looking at it right now but it will take a while (Definitely more than two hours)

Thanks appreciate that and also know about bankers rounding. However, if you notice the screen shot with the 'Test Value'. It rounded-up and not nearest. If bankers rounding was being used it should have rounded down (in this case). Plus when you start using UP and DOWN you get odd values. Which to mean are perhaps floating point versus double precision numeric issues - pure guess on my part.
But thank - I appreciate your response and efforts. I did find a less than optimum method was to use a 2 line python calculation using the decimal package.

cheers

Status update:

The issue you reported was addressed in the latest release

6.3.2.6

- Fixed: Round Transformation Function issues
- Fixed: Issues with exporting very large grids into excel files

Thank you very much. I will test my data and let you know

Appreciate the quick turn around

Regards
Bruce

Sorry to say but after uninstalling AETL and installing v.6.3.2.6 I still have the same issue. Please refer to the screen shots

The first shows the real data being pushed into the READER field, then the ROUND action basically rounding DOWN and not up. The next shot shows the ROUNDING ACTION setup and that the TEST VALUE and EXECUTION RESULT returns exactly what I would expect.




regards
bruce