FLOOR and CEILING functions round negative numbers to zero
The description for the CEILING function states:
The CEILING function rounds a number, away from zero, to the nearest multiple of significance.
Return Type: Numeric
Syntax: CEILING(number, significance)
There is no mention of treatment of negative numbers, and no examples using negative numbers. To me, rounding away from zero implies that rounding occurs for both positive and negative numbers... otherwise it is simply rounding up from zero.
I have discovered that both the FLOOR and CEILING functions round negative numbers to zero.
Why is this?
Is it possible to update the functions to round negative numbers?
Archer handles the FLOOR and CEILING functions based on Syncfusion, which is the calculation engine. I don't believe they expect negative numbers, but you can work around the issue with a calculation similar to the following:
FLOOR(ABS([Floor Number]),10)*([Floor Number]/ABS([Floor Number]))
CEILING(ABS([Ceiling Number]),10)*([Ceiling Number]/ABS([Ceiling Number]))
I created some calculated fields as a work-around, but I just wondered if anyone else had noticed and if there were any plans to "fix" the problem.