SQL 2000 Analysis Services : Calculated Members wrong rounding

I have a calculated member with the value expression :

[Measures].[Total Pool Distribution] / [Measures].[Net Days]

It appears to be truncating [Measures].[Net Days] to an integer before dividing. One example had the following values :

Total Pool Distribution : 225070
Net Days : 6.958
Calculated member : 37511.67

... which is 225070 / 6 and NOT 225070 / 6.958

Any idea what would cause this to truncate to integer before dividing?

Thanks

[512 byte] By [Jandd45] at [2007-12-29]

SQL Server

Site Classified