<< Click to Display Table of Contents >>

Navigation:  Reference >


Set the Locale in the Preferences window 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 transform.