A new function has been added to allow rounding of values in calculated fields. The function can be used to round off the results of one or more calculations within the formula.
The function can be set to round to a specific amount, and can round up, down, or to the nearest specified value.
For detailed instructions on setting up fields and creating formulas for calculated fields, please see the supplemental materials available from your Oceanwide Bridge Representative.
The syntax for the rounding function is as follows:
$Round(p0,p1,p2)
•p0 - Represents the value to be rounded. This may be a field reference, a formula, or another function. With fields, the current value of the field will be rounded. Formulas and functions will be calculated, and the result will be rounded. In all cases, the value must be numerical.
•p1 - Represents the precision or target value of the rounding. The p0 value will be rounded to the specified value, according to the option selected in p2.
Note: Decimal values are currently not supported. A whole number must be provided.
•p2 - Selects how the rounding will be performed. This parameter can have one of three values:
o 0 - Round from midpoint. This option will round the value up or down to the nearest target value.
o 1 - Round up. The value will always be rounded up to the target value.
o 2 - Round down. The value will always be rounded down to the target value.
Examples:
$Round([[PropertyValue]],50000,1)
Takes the current value of the Property Value field, and rounds it up to the nearest 50,000. This could be used to determine what category the property would fall into.
$Round([[AnnualLimit]]/3, 1,0)
Takes the current value of the Annual Limit field, divides by 3, then rounds off to the nearest whole number. This could be used to divide an annual amount into amounts for each four months, while preventing fractions.
Note: While the rounding function can be used multiple times throughout a formula, it is generally only used to round the final results of the calculations. Rounding a value that will be used for additional calculations can affect the accuracy of the final results.