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

