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%)