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
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.