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


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.