Article ID: 927945

Article Last Modified on 2/7/2007

APPLIES TO

- ProClarity Analytic Server

## SYMPTOMS

When you divide a decimal number by a calculated measure in a Multidimensional Expressions (MDX) definition, the result is incorrect in ProClarity Analytics Server 5.3. The result is calculated without using the decimal point in the decimal number. For example, the result of 100.00 divided by 0.5 is 20,000 instead of 200.

## CAUSE

This issue occurs because the calculated measure uses the currency format in the Microsoft SQL Server Analysis Services cube.

## RESOLUTION

To resolve this issue, use the **VAL** function in the MDX definition for the calculation. The **VAL** function explicitly instructs Analysis Services to use the decimal number.

Keywords: kbtshoot kbprb KB927945