<< Click to Display Table of Contents >>

Navigation:  Reference >


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.


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