Reference > Numbers

Set the locale according to how you want to interpret values as numbers. For example, if locale is set to US or UK then "123.45" is a number and "123,45" isn't, and vice versa if locale is Germany or France.

An integer is a whole number. E.g. "1.0" or "1,0" (depending on your locale), "0", "-1" and "1e3" are considered integers.

Numeric calculations are accurate to approximately 16 digits of precision. This means that Easy Data Transform may consider 12345678901234567 and 12345678901234568 to be equal, for example using the = operator in a Filter transform.

"NaN" means 'not a number'. It can be returned by some calculations, for example using Calculate to raise 1000 to the power 1000 will overflow numerically and return "NaN".

You can change the format of numbers using the Num Format transform.

You can do numeric calculations, such as multiplying 2 columns, using the Calculate or Javascript transforms.

You can change the base of integers using the Num Base transform.