Forum Discussion
number roundiing
how do I limit calculated numbers to only whole numbers (no rounding)
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.
