Skip to main content
Previous section   Next section


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
Copy code to clipboard