Crystal Reports for Eclipse Designer Guide

Round

Description
Round rounds to the nearest whole number if the #places argument is excluded.
Overloads
  • Round (x)
  • Round (x, #places)
  • Arguments
  • x is a Number or Currency to be rounded off.
  • #places is a whole number indicating the number of decimal places x is to be rounded off to.

    Note: The value of #places can range from -20 to 10 (inclusive).
  • Returns
    Number
    Action
    Round rounds to the nearest whole number if the #places argument is excluded. If the value to the right of the decimal point is .499 or below, the program rounds to the next lowest number. If the value to the right of the decimal point is .5 or above, it rounds to the next highest number.
    If the #places argument is used, the value in x is rounded to the nearest decimal place indicated by #places. Specifying #places as 0 works identical to leaving the #places argument off. You can also specify a negative number for #places; the number will be rounded to the nearest tenth (.1), hundredth (.01), or thousandth (.001), and so on.
    The value of #places can range from -20 to 10 (inclusive).
    Typical uses
    Use Round any time rounding off a value to a particular decimal place is more appropriate than using the original value.
    Examples
    Round(1.23456)
    Returns 1.
    Round(1.499)
    Returns 1.
    Round(1.5000)
    Returns 2.
    Round(2345.23456,4)
    Returns 2345.2346.
    Round(2345.23456,3)
    Returns 2345.235.
    Round(2345.23456,2)
    Returns 2345.23.
    Round(2345.23456,0)
    Returns 2345.
    Round(2345.23456,-1)
    Returns 2350.
    Round(2345.23456,-2)
    Returns 2300.
    Round(2345.23456,-3)
    Returns 2000.
    Round(1.234499,3)
    Returns 1.234.
    Round(1.234500,3)
    Returns 1.235.
    Round({file.AMOUNT},1)
    Returns 1854.5 where Amount = 1854.49.
    Round({file.AMOUNT})
    Returns 1854.00 where Amount = 1854.49.
    Round({file.AMOUNT})
    Returns 1855.00 where Amount = 1854.51.
    Round({file.WEIGHT} / 100)
    Returns 4 where Weight = 424.
    Round({file.WEIGHT} / 100)
    Returns 5 where Weight = 451.
    Round((A * B) / C)
    Returns 11 where A = 25, B = 3, and C = 7.
    Round(file.AMOUNT,1)
    Returns 1854.5 where Amount = 1854.51.
    Round({file.WAGE} * {file.HOURS WORKED}, 2)
    Returns $146.63 where Wage = $5.75 and Hours worked = 25.5.
    Comments
    Rounding is also a feature available as a formatting option for numerical values in fields.
    Be aware that using field formatting features may affect how values are used in formulas.



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