Why is my formula only returning whole numbers?

Data Pipeline

If you’re performing a calculation on integers, then only integers will be returned. If you want your results to have decimal precision you’ll need to convert your data type to decimal.

You can do this by adding an Edit Column step in the Data Pipeline. Use a Custom Formula and multiply your formula numerator by 1.0, for example:

(1.0 * "Column 1")/"Column 2"

Multiplying “Column 1” by 1.0 will force the value to be converted to the data type “real” and show decimal precision.

Related Data Pipeline Help Articles

See more