mdx - Olap cube calculated member, how to round -

i created calculated member , value is:

[measures].[value] / [measures].[recuento fact result] 

i want round value, , save first 2 decimals, example:

[measures].[value]=10 [measures].[recuento fact result]=3 

my calculated member = 3.3333333333333333333

i want 3.33

how can this?

try this:

round(   [measures].[value]/[measures].[recuento fact result]   , 2  //<<you can adjust number of dec places required ) 

another interesting rounding function used in mdx fix

fix(   [measures].[value]/[measures].[recuento fact result] ) 

you'll integer part of answer returned.

as aside - should defend against divide 0 possibilities measure yours this:

round(   iif(     [measures].[recuento fact result] = 0,     ,null     ,[measures].[value]/[measures].[recuento fact result]     )   ,2 )