schemal檔案計算列，除法除數為0時顯示為null問題

解決方案：

<Formula>          IIf([Measures].[惠及企業數]=0, 0, [Measures].[惠企金額]/[Measures].[惠及企業數] )
</Formula>
           

一個完整的schemal檔案：

<?xml version="1.0"?>
<Schema name="zhida">
<Dimension name="Time" type="TimeDimension">
<Hierarchy hasAll="false">
<Table name="BB_MV_ZD_HQLM_HZ_CUBE"/>
<Level name="年" column="YEAR" uniqueMembers="true" levelType="TimeYears" type="Numeric"/>
</Hierarchy>
</Dimension>
<Dimension name="地區">
<Hierarchy hasAll="true" allMemberName="All 省">
<Table name="BB_MV_ZD_HQLM_HZ_CUBE"/>
<Level name="省" column="SHENG" uniqueMembers="false"/>
<Level name="市" column="SHI" uniqueMembers="false"/>
<Level name="區縣" column="XIAN" uniqueMembers="false"/>
</Hierarchy>
</Dimension>
<Dimension name="資金名稱">
<Hierarchy hasAll="true" allMemberName="資金名稱">
<Table name="BB_MV_ZD_HQLM_HZ_CUBE"/>
<Level name="資金名稱" column="SPFNAME"  uniqueMembers="false"/>
</Hierarchy>
</Dimension>
<Dimension name="項目名稱">
<Hierarchy hasAll="true" allMemberName="項目名稱">
<Table name="BB_MV_ZD_HQLM_HZ_CUBE"/>
<Level name="項目名稱" column="PROJNAME"  uniqueMembers="false"/>
</Hierarchy>
</Dimension>
<Cube name="惠企利民">
<Table name="BB_MV_ZD_HQLM_HZ_CUBE"/>
<DimensionUsage name="時間" source="Time"/>
<DimensionUsage name="地區" source="地區"/>
<DimensionUsage name="資金名稱" source="資金名稱"/>
<DimensionUsage name="項目名稱" source="項目名稱"/>
<Measure name="惠及企業數" column="ENT_SL" aggregator="sum"/>
<Measure name="惠企金額" column="ENT_AMT" aggregator="sum"/>
<Measure name="惠及人員數" column="RY_SL" aggregator="sum"/>
<Measure name="利民金額" column="RY_AMT" aggregator="sum"/>
<CalculatedMember                name="利民平均金額"          dimension="Measures">
<Formula>
       IIf([Measures].[惠及人員數]=0, 0, [Measures].[利民金額]/[Measures].[惠及人員數] )  </Formula>
<CalculatedMemberProperty name="FORMAT_STRING" value="#,##0.00"/>
</CalculatedMember>
<CalculatedMember                name="惠企平均金額"                dimension="Measures">
<Formula>          IIf([Measures].[惠及企業數]=0, 0, [Measures].[惠企金額]/[Measures].[惠及企業數] )
</Formula>
<CalculatedMemberProperty name="FORMAT_STRING" value="#,##0.00"/>
</CalculatedMember>
</Cube>
</Schema>