Div
Returns the integer component of a division operation
Category: math
Syntax:
Div([dividend], [divisor])
Returns: Integer
Context Filtering: ✓ Yes
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
dividend |
number or column |
✓ Yes | The number to be divided |
divisor |
number or column |
✓ Yes | The number to divide by |
Allowed Column Types for dividend: INT, FLOAT, DECIMAL
Allowed Column Types for divisor: INT, FLOAT, DECIMAL
Validation
- Minimum parameters: 2
- Maximum parameters: 2
Examples
Div([Dividend], [Divisor])
Returns the integer component of division for each pair of values
Div(19, 5)
19 divided by 5 is 3.8. Returns the integer component 3
Result: 3
Div(2, 3)
If there is no integer component (0.6), the result is 0
Result: 0