number roundiing

Occasional Visitor

how do I limit calculated numbers to only whole numbers (no rounding)

1 Reply



Generally, use INT(expression) or TRUNC(expression).


See the difference with negative values; for example, -1.9.


FLOOR(expression,1) is the same as INT(expression).

ROUNDDOWN(expression,0) is the same as TRUNC(expression).


All behave the same with positive values; for example, 1.9.