Rounding in report writing is always a tricky business.
Does one need to round up or round down, that is the question?
In SQL Server Reporting Services there are two rounding functions:
- CEILING()
Returns the nearest integer greater than or equal to the specified value, i.e. it will round up, regardless of the values to the right of the decimal point.
=CEILING(1998.67) Returns 1999
=CEILING(107741.11) Returns 107742
- FLOOR()
Returns the nearest integer less than or equal to the specified
value, i.e. it will round down, regardless of the values to the right of
the decimal point.
=FLOOR(1998.67) Returns 1998
=FLOOR(107741.11) Returns 107741
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us |
