<< Click to Display Table of Contents >> Navigation: Reference > Numbers |
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.