Divide function

Divides each value in the column by a positive or negative decimal or divides each value in two columns.

Namespace

• arithmetic

• decimal

Input

Numeric values

Output

Numeric values

Applied to one column

Divides each value in a column by the specified positive or negative decimal value.

Syntax

set-column :output_column column / <decimal_value>

Examples

Divides each value by 10 in the price column and outputs results to the price_new column:

set-column :price_new price / 10

set-column :price_new decimal:divide(price,10)

Applied to two columns

Divides values in two columns. 

Syntax

set-column :output_column arithmetic:divideq(column1,column2)

Example

Divides values in and col1 and col2 columns and outputs results to a new column col3:

set-column :col3 arithmetic:divideq(col1, col2)