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)"/>