idiv(X;Y)

Returns the quotient after dividing one integer value by another. The result is an integer data type.

Syntax

idiv(X;Y)

Input

Argument Type Description
X integer The dividend of the integer division operation
Y integer The divisor of the integer division operation

Note(s): X and Y must be 32-bit integers (between -2147483646 and +2147483646).

Return Value

Returns the quotient of X divided by Y. The result is an integer data type.

If the values of X or Y are N/A, they are handled according to their internal representation like any other number.

Example

In this example, the idiv(X;Y) function returns the result of sales divided by units on the pub.demo.retail.item table. The new column contains integer data type values.

<base table="pub.demo.retail.item"/>
<colord cols="transid, account, store, date, sku, units, sales"/>
<willbe name="salesdivunits" value="idiv(sales;units)"/>