#NUM error on Pivot Table

From: TrevH (TrevH_at_discussions.microsoft.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 06:45:20 -0700

Hi All

I have a Pivot table built ontop of an AS cube that is giving me a #Num
error on some of my values. The field giving the problem is Gross Profit
cents per litre. The formula is:

Iif([Measures].[Volume] = 0 or [Measures].[Gross Profit] = 0,
null,([Measures].[Gross Profit]/[Measures].[Volume])*100)

When The Volume Measure is 0, I get the #NUM error on the Gross Profit cents
per litre field instead of displaying 0 as it should as per the above
formula. I thought I had catered for the division by 0 problem using the Iif
syntax above. Also when I hover over the #num error, the value is given as
-1.#ind. I have used this formula with success in other cubes.

Any help would be appreciated.

Thanks