INT
You can use the INT function when you need only the integer portion of a number.
- Syntax:
- INT (single-number-expression)
- Meaning:
- INT (number_to_convert)
- Returns:
- A single integer
INT returns the integer portion of a number. The result is the integer part of number_to_convert. Any fractional part after the decimal point is dropped.
Examples
- INT (1.45)
Returns 1
- INT (3.6)
Returns 3
- INT (Purchase:Amt - Discount:Amt)
Subtracts Discount:Amt from Purchase:Amt and returns the result as a whole number.
Related functions
- MOD
- ROUND
- TRUNCATE