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.

Open your Chart in the Data Explorer. Edit your calculated column in the Data Pipeline, and multiply your formula numerator by 1.0, like so:

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

Related Data Pipeline Help Articles

See more