Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference INT
Functions and Expressions Reference Guide
131
INT
The INT function returns the integer portion of a number.
Syntax
INT (single-number-expression)
Meaning
INT (number_to_convert)
Returns
This function returns a single-integer.
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.
Uses
Use
INT when you need only the integer portion of a number.
Related Functions
MOD, ROUND, TRUNCATE