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