Skip to main content
Previous sectionNext section

ROUND

Evaluates a numeric MDX expression and returns a rounded value. This function is an InterSystems extension to MDX.

Returned Type

This function returns a numeric expression.

Syntax and Details

ROUND(numeric_expression,decimal_places)

Where:

  • numeric_expression is a numeric expression.

  • decimal_places is an integer literal that specifies the number of decimal places to use for the returned value. The default is 0.

Example

The following shows a simple example:

SELECT ROUND(MEASURES.[avg allergy count],2) ON 0, 
patgrpd.[patient group].MEMBERS ON 1 FROM patients
 
                                     ROUND
1 Group A                              0.97
2 Group B                              1.06
3 None                                 0.97
Copy code to clipboard