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
arithmeticdecimal
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)