Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?


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



  • 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.


The following shows a simple example:

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