Jul 13 2022 04:48 PM
how do I limit calculated numbers to only whole numbers (no rounding)
Jul 13 2022 08:40 PM
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.