Crystal Reports for Eclipse Designer Guide

Ceiling

Description
Ceiling returns a number that has been rounded to the multiple that you specify.
Overloads
  • Ceiling (x)
  • Ceiling (x, multiple)
  • Arguments
  • x is a value to be rounded.
  • multiple is a multiple that you want to round the x value to.
  • Returns
    Number
    Action
    This function rounds up (away from zero).
    Examples
    Ceiling(3.5,1)
    Returns 4.
    Ceiling(-2.5,-2)
    Returns -4.
    Ceiling(-2.5,2)
    Returns -4.
    Ceiling(5.43,.05)
    Returns 5.45.
    Ceiling(.43,-1)
    Returns 1.
    Comments
  • Crystal Reports ignores the sign of the multiple, and the result of the function takes the sign of the first parameter.
  • Values are always rounded up when they are adjusted away from zero (without regard to the sign of the value). If number is an exact multiple of multiple, no rounding occurs.



  • SAP BusinessObjects
    http://www.sap.com/sapbusinessobjects/
    Support services
    http://service.sap.com/bosap-support/
    Product Documentation on the Web
    http://help.sap.com/