Modulo function

Returns the remainder when dividing each value in the column by a positive decimal or returns the remainder when dividing each value in two columns.

Namespaces

• arithmetic

• decimal

Input

Numeric values

Output

Numeric values

Applied to one column

Returns the remainder when dividing each value in the column by a positive decimal.

Syntax

For non-decimal columns:

set-column :column column % <decimal_value>

For decimal columns:

set-column :column decimal:divider(column, <decimal_value>)

Example

Divides each value in the price column by 10 and returns the remainder.

For non-decimal columns:

set-column :price price % 10

For decimal columns:

set-column :price decimal:divider(price, 10)

Applied to two columns

Divides the values in two columns.

Syntax

For numeric values:

set-column :column arithmetic:divider(column1,column2)

Example

Divides values in price and cost columns and returns the remainder.

set-column :price arithmetic:divider(price,cost)