Test for Divide By Zero

[IanWaterman]

Real Newbie to MDX

Can any one recommend a good book?

In mean time I need to modify my query to test for zero

with member [Measures].[Average Premium] as '[Measures].[NET PREMIUM]/([Measures].[POLICY COUNT], [Year].CurrentMember, [Transaction Type].CurrentMember)'

select NON EMPTY {[Measures].[NET PREMIUM], [Measures].[TOTAL AMOUNT], [Measures].[POLICY COUNT], [Measures].[Average Premium]} ON COLUMNS,
NON EMPTY Crossjoin(Hierarchize({[Year.Year].[All Years]}), {[Transaction Type.Transaction Type].[All transaction type]}) ON ROWS
from [Policy Analysis]

I want to return zero if either Net Premium or Policy Count are zero.

Thank you

Ian