# Math functions

## Absolute value

Calculates the absolute value of numerical values in the column.

### 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>-1989</p> </li> <li> <p>12</p> </li> </ul> | <ul> <li> <p>1989</p> </li> <li> <p>12</p> </li> </ul> |

## Add

Performs a calculation on this column with another one or a fixed 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. |
| Use with | <ul> <li> <p><span>Value</span>: Select this option to add a fixed value, set in the <span>Value</span> field.</p> </li> <li> <p><span>Column</span>: Select this option to add 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 |
| --- | --- | --- |
| 10 | <ul> <li> <p>Use with: Value</p> </li> <li> <p>Value: 2</p> </li> </ul> | 12 |

## Cosine

Computes the trigonometric cosine of the column values.

### 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 |
| --- | --- |
| 50 | 0.96496602849211 |

## Divide

Performs a calculation on this column with another one or a fixed 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. |
| Use with | <ul> <li> <p><span>Value</span>: Select this option to divide the column values by a fixed value, set in the <span>Value</span> field.</p> </li> <li> <p><span>Column</span>: Select this option to divide the column values 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 |
| --- | --- | --- |
| 10 | <ul> <li> <p>Use with: Value</p> </li> <li> <p>Value: 2</p> </li> </ul> | 5 |

## Exponential

Calculates the exponential of the column values.

### 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 |
| --- | --- |
| 5 | 148.41315910258 |

## Logarithm

Calculates the base 10 logarithm of the column values.

### 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 |
| --- | --- |
| 5 | 0.69897000433602 |

## Max

Raises numerical values to reach a specified value or the value from another column.

### 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. |
| Use with | <ul> <li> <p><span>Value</span>: Select this option to use a fixed value as max, set in the <span>Value</span> field.</p> </li> <li> <p><span>Column</span>: Select this option to use values from another column as max, 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>-150</p> </li> <li> <p>72</p> </li> <li> <p>42</p> </li> </ul> | <ul> <li> <p>Use with: Value</p> </li> <li> <p>Value: 50</p> </li> </ul> | <ul> <li> <p>50</p> </li> <li> <p>72</p> </li> <li> <p>50</p> </li> </ul> |

## Min

Lowers numerical values to reach a specified value or the value from another column.

### 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. |
| Use with | <ul> <li> <p><span>Value</span>: Select this option to use a fixed value as min, set in the <span>Value</span> field.</p> </li> <li> <p><span>Column</span>: Select this option to use values from another column as min, 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>-150</p> </li> <li> <p>72</p> </li> <li> <p>42</p> </li> </ul> | <ul> <li> <p>Use with: Value</p> </li> <li> <p>Value:&nbsp;50</p> </li> </ul> | <ul> <li> <p>-150</p> </li> <li> <p>50</p> </li> <li> <p>42</p> </li> </ul> |

## Modulo

Calculates the remainder of a division operation.

### 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. |
| Use with | <ul> <li> <p><span>Value</span>: Select this option to perform the calculation with a fixed value, set in the <span>Value</span> field.</p> </li> <li> <p><span>Other column</span>: Select this option to perform the calculation 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 |
| --- | --- | --- |
| 10 | <ul> <li> <p>Use with:&nbsp;Value</p> </li> <li> <p>Value: 3</p> </li> </ul> | 1 |

## Multiply

Performs a calculation on this column with another one or a fixed 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. |
| Use with | <ul> <li> <p><span>Value</span>: Select this option to multiply the column values by a fixed value, set in the <span>Value</span> field.</p> </li> <li> <p><span>Column</span>: Select this option to multiply the column values by 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 |
| --- | --- | --- |
| 10 | <ul> <li> <p>Use with: Value</p> </li> <li> <p>Value: 2</p> </li> </ul> | 20 |

## Natural logarithm

Calculates the natural logarithm of the column values.

### 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 |
| --- | --- |
| 5 | 1.60943791243 |

## Negate

Negates the column values. Positive values become negative and negative values become positive.

### 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>75012</p> </li> <li> <p>-1500</p> </li> </ul> | <ul> <li> <p>-75012</p> </li> <li> <p>1500</p> </li> </ul> |

## Power

Uses a specific value or the values from another column as exponent for the column values.

### 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. |
| Use with | <ul> <li> <p><span>Value</span>: Select this option to use a fixed value as exponent, set in the <span>Value</span> field.</p> </li> <li> <p><span>Other column</span>: Select this option to values from another column as exponent, 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>3</p> </li> <li> <p>10</p> </li> </ul> | <ul> <li> <p>Use with: Value</p> </li> <li> <p>Value: 3</p> </li> </ul> | <ul> <li> <p>27</p> </li> <li> <p>1000</p> </li> </ul> |

## Sine

Computes the trigonometric sine of the column values.

### 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 |
| --- | --- |
| 50 | -0.26237485370393 |

## Square root

Calculates the square root of the column values.

### 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>25</p> </li> <li> <p>1600</p> </li> </ul> | <ul> <li> <p>5</p> </li> <li> <p>40</p> </li> </ul> |

## Subtract

Performs a calculation on this column with another one or a fixed 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. |
| Use with | <ul> <li> <p><span>Value</span>: Select this option to subtract a fixed value from the column values, set in the <span>Value</span> field.</p> </li> <li> <p><span>Column</span>: Select this option to subtract values from another column from the base 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 |
| --- | --- | --- |
| 10 | <ul> <li> <p>Use with: Value</p> </li> <li> <p>Value: 2</p> </li> </ul> | 8 |

## Tangent

Computes the trigonometric tangent of the column values.

### 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 |
| --- | --- |
| 50 | -0.27190061199763 |