number roundiing

Occasional Visitor

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

1 Reply

@vic_berniklaumyuserna 

 

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.