INTEGER()

INT() returns the integer value of a numeric expression or field value. Use INT() to either ignore or isolate the fractional part of an expression.

Note: By definition, numbers following a decimal are truncated.

Function Format

INTEGER(N)

The INT() function returns the integer value of the numeric expression or field value N.

Note: Some software packages define the INT of a negative value as being the next lower value, that is, INT(-7.9) = -8. This is not the case with Analyzer. Negative values in financial data tend to mean accounting credits (not negatives).

Examples

INT(7.9)= 7

INT(-7.9)= -7

To create the field Cents, which is the portion of the Amount field you are interested in, specify:

Amount - INT(Amount)