LOGIC_IF ( condition item , true item, false item)

LOGIC_IF ( condition item , true item, false item)

This formula takes ta value from a condition ITEM to decide to retrieve the true or false ITEMs

Formula:

LOGIC_IF ($1 , $2, $3)

Calculation

If $1 is true return the data in field $2, otherwise returns the data in field $3)

Note

'0', 'false' or empty string in answer will be considered as false value. If question is BOOLEAN type also 'N' (answered 'No') in answer value will be considered as false.

Other values (only numbers) will be considered as true. Otherwise, e.g. characters, will be false.