Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brian312
Starting Member
1 Post |
 Posted - 2006-02-01 : 16:12:00
|
| Hello,I have a calculated member that composed of dividing two other calculated members. The calculation is incorrect and is ignoring the decimal places in both of the source measures of the equation.Example:Calculated Member 1 = 300.01Calculated Member 2 = 10.25Calculated Member 3 = (CM1 / CM2 ) = 30 INCORRECT!!!Answer should be = 29.269The MDX that I am using is as follows:Calculated Member 1 (Booked Amount YTD):Sum(PeriodsToDate([Fiscal].[Date].[Fiscal Year]),[OH Booked Amount])Calculated Member 2 (Units YTD)Sum(PeriodsToDate([Fiscal].[Date].[Fiscal Year]),[OH Units])Calculated Member 3 (Booked Amount / Unit)Measures.[Booked Amount YTD] / Measures.[Units YTD]This seems like a fairly common and straight forward type of calculation, taking the YTD amount / YTD units to come up with YTD amount per unit. When I create a calculated member with the hardcoded values of 30.01 / 10.25 I get the correct answer of 29.269. Am I missing something with formatting? Is this a bug in Analysis Services?Any help would be appreciated.Thanks in advance.Brian |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Calculated Member - Ignoring Decimals