-1.#INF, -Infinity and -1.#IND

#1

I have the following errors showing in my cube and passing through to my
reports. My MDX calculated expressions are as follows:

AdjustedGrossProfitPercent = [Measures].[AdjustedGrossProfitAmount] /
[Measures].[EmployeeRevenueByProjectByMonth]

AND

[CalculatedBillRate] = [Measures].[EmployeeRevenueByProjectByMonth] /
[Measures].[EmployeeWorkedHoursByProjectByMonth]

Any ideas how I can remove these errors? I assume there are related to a
divide by zero error?

#2

try:
iif(measures.[a] = 0 or measures.[b] = 0, 0 , measures.[a] / measures.[b])

if 1 of the 2 measures = 0 then return 0 else execute the calculation

"Scott" <Scott (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have the following errors showing in my cube and passing through to my
reports. My MDX calculated expressions are as follows:

AdjustedGrossProfitPercent = [Measures].[AdjustedGrossProfitAmount] /
[Measures].[EmployeeRevenueByProjectByMonth]

AND

[CalculatedBillRate] = [Measures].[EmployeeRevenueByProjectByMonth] /
[Measures].[EmployeeWorkedHoursByProjectByMonth]

Any ideas how I can remove these errors? I assume there are related to a
divide by zero error?

#3

Perfect! That worked. Thanks

"Jeje" wrote:

Quote:

try:
iif(measures.[a] = 0 or measures.[b] = 0, 0 , measures.[a] / measures.[b])

if 1 of the 2 measures = 0 then return 0 else execute the calculation

"Scott" <Scott (AT) discussions (DOT) microsoft.com> wrote in message
news

2033253-2B42-496A-9667-38598DDA01D7 (AT) microsoft (DOT) com...
I have the following errors showing in my cube and passing through to my
reports. My MDX calculated expressions are as follows:

AdjustedGrossProfitPercent = [Measures].[AdjustedGrossProfitAmount] /
[Measures].[EmployeeRevenueByProjectByMonth]

AND

[CalculatedBillRate] = [Measures].[EmployeeRevenueByProjectByMonth] /
[Measures].[EmployeeWorkedHoursByProjectByMonth]

Any ideas how I can remove these errors? I assume there are related to a
divide by zero error?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

-1.#INF, -Infinity and -1.#IND

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

-1.#INF, -Infinity and -1.#IND - 05-22-2006 , 12:52 PM

Re: -1.#INF, -Infinity and -1.#IND - 05-22-2006 , 01:49 PM

Re: -1.#INF, -Infinity and -1.#IND - 05-22-2006 , 03:15 PM