When using the Transform and Cleanse functionality within Toad Data Point the result of the calculation is incorrectly rounding the result to the nearest whole number. Due to this calculations are not working correctly within the transform. Please see the examples below of the issue. This only appears to affect calculations using the built in functions, not the SQL Transform functions.

Formula with "correct" output (not rounded)

Inputs into Formula

Correct Output

Here is the output in error and the associated formula

Formula not working correctly

Incorrect Output, note the values are rounded

These screenshots were taken from the same Transform and Cleanse session with both columns included. Inputs are the same for both formulas

Any assistance would be appreciated.