IIF Function

Function:

IIF

Syntax:

IIF(condition , value if true , value if false )

Description:

This function enables you to make a conditional expression, for example, to avoid division by zero or null fields.

Example: here the « measure name » measure is the QTY field (Quantity) and the « Time Dimension Name » dimension is the DATE.[by Month] dimension.

IIF(([measures].[QTY],DATE.[by Month].currentmember.prevmember)<>0,([measures].[QTY]-([measures].[QTY],DATE.[by Month].currentmember.prevmember))/([measures].[QTY],DATE.[by Month].currentmember.prevmember),NULL)