ROUND
Rounds a number to a specified number of digits.
Category
Math
Measure
Select a measure name from the list.
Decimal
Type a value for the number of digits to which to round the number. If you omit this value, ROUND uses 0. Specify a positive integer to indicate the number of places to the right of the decimal point to which to round. Specify a negative integer to indicate the number of places to the left of the decimal point to which to round.
Returns
Data Analyzer calculates ROUND for the measure you selected and displays the values, rounded to a specified number of digits in the cross tab.
Example
Apply ROUND to the sales revenue measure and specify -2 for the value. A sales revenue value of $12,148 appears as $12,100.
Apply ROUND to the sales revenue measure and specify 1 for the value. A sales revenue value of $878.87 appears as $878.9.

Additional Links:

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2