# Numbers functions

In the case that your data is not detected as numbers, you need to first apply the Convert to numbers function to the column with numbers before applying any other number-related function. The separator information that you have to fill correspond to the input format separators to parse a text into number, not the display format separator of numbers.

## Compare numbers

Compares the numbers in the column with a specific value, or values from another column. The function will return TRUE if the condition set by the operator is met, otherwise it will return FALSE.

### Properties

| Property | Configuration |
| --- | --- |
| Columns to process | Select the column or columns on which you want to apply the function.<br><br>If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Comparison operator | Select the operator to use for the comparison:<br><br><ul> <li> <p>= equals</p> </li> <li> <p>!= is not equal</p> </li> <li> <p>&gt; is greater than</p> </li> <li> <p>&gt;= is greater than or equals</p> </li> <li> <p>&lt; is lower than</p> </li> <li> <p>&lt;= is lower than or equals</p> </li> </ul> |
| Use with | <ul> <li> <p><span>Value</span>: Select this option to compare the column against a fixed value, set in the <span>Value</span> field.</p> </li> <li> <p><span>Other column</span>: Select this option to compare the column with values from another column, set in the <span>Column</span> drop-down list.</p> </li> </ul> |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |

### Example

| Input | Configuration | Output |
| --- | --- | --- |
| <ul> <li> <p>12345</p> </li> <li> <p>42</p> </li> <li> <p>365</p> </li> </ul> | <ul> <li> <p>Comparison operator: &gt;</p> </li> <li> <p>Use with: Value</p> </li> <li> <p>Value: 300</p> </li> </ul> | <ul> <li> <p>TRUE</p> </li> <li> <p>FALSE</p> </li> <li> <p>TRUE</p> </li> </ul> |

## Convert to numbers

Converts the type of data contained in the column so that it is interpreted as numbers in the system.

### Properties

| Property | Configuration |
| --- | --- |
| Columns to process | Select the column or columns on which you want to apply the function.<br><br>If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Decimal separator | Enter a character to act as decimal separator for number data. |
| Thousand separator | Enter a character to act as decimal separator for number data. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |

## Format number

Changes how numeric values are displayed using predefined or custom patterns.

### Properties

| Property | Configuration |
| --- | --- |
| Columns to process | Select the column or columns on which you want to apply the function. |
| Output format | Select one of the predefined patterns from the drop-down list or enter a custom format to apply on the numbers:<br><br><ul> <li> <p><code>1,000 (#,##0)</code> </p> </li> <li> <p><code>1,000.1 (#,##0.0)</code> </p> </li> <li> <p><code>1,000.12 (#,##0.00)</code> </p> </li> <li> <p><code>12% (0%)</code> </p> </li> <li> <p><code>12.3% (0.0%)</code> </p> </li> <li> <p><code>12.34% (0.00%)</code> </p> </li> <li>Custom, to enter your specific number format, set in the <span>Custom format</span> field.</li> </ul> |
| Decimal separator | Optionally enter a character to act as decimal separator for the output. |
| Thousand separator | Optionally enter a character to act as thousand separator for the output. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |

### Example

| Input | Configuration | Output |
| --- | --- | --- |
| <ul> <li> <p>0</p> </li> <li> <p>19021.04</p> </li> <li> <p>1429.68</p> </li> </ul> | <ul> <li> <p>Output format: 1,000.12 (#,##0.00)</p> </li> <li> <p>Decimal separator: .</p> </li> <li> <p>Thousand separator: ,</p> </li> </ul> | <ul> <li> <p>0.00</p> </li> <li> <p>19,021.04</p> </li> <li> <p>1,429.68</p> </li> </ul> |

## Remove fractional part

Removes the fractional part of a number to round towards zero.

### Properties

| Property | Configuration |
| --- | --- |
| Columns to process | Select the column or columns on which you want to apply the function.<br><br>If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |

### Example

| Input | Output |
| --- | --- |
| <ul> <li> <p>3.14</p> </li> <li> <p>-19.89</p> </li> </ul> | <ul> <li> <p>3</p> </li> <li> <p>-19</p> </li> </ul> |

## Remove negative values

Replaces negative integers or decimal values with a null value.

### Properties

| Property | Configuration |
| --- | --- |
| Columns to process | Select the column or columns on which you want to apply the function.<br><br>If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |

### Example

| Input | Output |
| --- | --- |
| <ul> <li> <p>121021</p> </li> <li> <p>-365</p> </li> </ul> | <ul> <li> <p>121021</p> </li> <li> <p>null</p> </li> </ul> |

## Round value using ceil mode

Rounds up values to the nearest number, depending on the precision you set.

### Properties

| Property | Configuration |
| --- | --- |
| Columns to process | Select the column or columns on which you want to apply the function.<br><br>If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Precision | Set the number of decimals that you want to keep. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |

### Example

| Input | Configuration | Output |
| --- | --- | --- |
| 3.14 | Precision: 0 | 3 |
| 3.14 | Precision:1 | 3.2 |

## Round value using down mode

Rounds a value towards zero.

### Properties

| Property | Configuration |
| --- | --- |
| Columns to process | Select the column or columns on which you want to apply the function.<br><br>If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Precision | Set the number of decimals that you want to keep. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |

### Example

| Input | Configuration | Output |
| --- | --- | --- |
| 3.74 | Precision: 0 | 3 |
| -3.74 | Precision: 1 | -3.7 |

## Round value using floor mode

Rounds down value to the nearest number, depending on the precision you set.

### Properties

| Property | Configuration |
| --- | --- |
| Columns to process | Select the column or columns on which you want to apply the function.<br><br>If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Precision | Set the number of decimals that you want to keep. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |

### Example

| Input | Configuration | Output |
| --- | --- | --- |
| 3.74 | Precision: 0 | 3 |
| 3.74 | Precision: 1 | 3.7 |

## Round value using half up mode

Rounds value to the closest number, depending on the precision you set.

### Properties

| Property | Configuration |
| --- | --- |
| Columns to process | Select the column or columns on which you want to apply the function.<br><br>If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Precision | Set the number of decimals that you want to keep. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |

### Example

| Input | Configuration | Output |
| --- | --- | --- |
| 3.14 | Precision: 0 | 3 |
| 3.74 | Precision: 0 | 4 |
| 3.74 | Precision: 1 | 3.7 |
| 3.78 | Precision: 1 | 3.8 |