Learning
Community
Open Exchange
Global Masters
InterSystems IRIS Data Platform 2019.3 / Application Development / InterSystems MDX Reference / MDX Functions / ROUND
Previous section   Next 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
Previous section   Next section