Numbers

<< Click to Display Table of Contents >>

Navigation:  Reference >

Numbers

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.

 

You can change the base of integers using the Num Base transform.