Skip to content

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