Functions (all)

ItemIf

Function Name:

ItemIf

Description:

Returns the parameter 2 data item if the boolean expression in parameter 1 is True. If the boolean expression is not True, it returns the parameter 3 data item.

See Conditional Expressions.

Minimum FH Version:

4.0

No. of Parameters:

3

Return Type:

Data Item

Parameter 1:

A boolean expression (True or False)

Parameter 2:

A data item. The data item to return if parameter 1 is True.

Parameter 3:

A data item. The data item to return if parameter 1 is False.

Examples:

=ItemIf(%INDI.SEX% = "Male",%INDI.FAMS>WIFE%,%INDI.FAMS>HUSB%)