Numbers

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