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

Feedback