Wrox Programmer Forums Calculated Member - Ignoring Decimal
 | Search | Today's Posts | Mark Forums Read
 SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
 Welcome to the p2p.wrox.com Forums. You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

February 1st, 2006, 05:15 PM
 Registered User Join Date: Feb 2006 Location: , , . Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts
Calculated Member - Ignoring Decimal

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.01
Calculated Member 2 = 10.25
Calculated Member 3 = (CM1 / CM2 ) = 30 INCORRECT!!!

The 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.

Brian

May 9th, 2006, 02:37 AM
 Friend of Wrox Join Date: May 2006 Location: Helsingborg, , Sweden. Posts: 246 Thanks: 0 Thanked 0 Times in 0 Posts

Just for fun, use CONVERT or CAST.

 Similar Threads Thread Thread Starter Forum Replies Last Post Ignoring first element using for-each amhicraig XSLT 1 December 4th, 2007 05:41 PM Ignoring in False clause? gabster XSLT 2 September 7th, 2007 08:29 AM decimal data type all 0's after decimal gobotsoup SQL Server ASP 1 February 28th, 2007 02:32 PM my stylesheet is ignoring nodes gonzalocordero XSLT 8 June 30th, 2006 09:17 PM Ignoring Namespace Pt2 Chamkaur XSLT 1 June 19th, 2006 05:08 AM