NULL value treatment

[apad]

Hi

I get a fact table with 2 key fields (1 key for Time dimension and 1 key for Product dimension) and 3 numéric fields for measures (MeasureA, MeasureB, MeasureC)
Few records have the value NULL for the field MeasureC

I create a Calculated Member with this formula :
IIf(MeasureC is NULL, MeasureA x MeasureB, MeasureA x MeasureC)

I realise that NULL values was converted in 0, so expression "MeasureC is NULL" is ever FALSE. The result of this Member is MeasureA x MeasureC (=0 when MeasureC is NULL)

How can I treat the NULL value ?

Thanks

 

[apad]

I found a "solution".

I created a Measure named MeasureCIsNull with the property

Source Column = 
CASE WHEN "dbo"."FAITS"."MEASUREC" IS NULL THEN 1 ELSE 0 END

I modified my Calculated Member like this :

Iif(MeasureCIsNull = 1, MeasureA x MeasureB, MeasureA x MeasureC).

I'm not proud but I didn't find better.