Help Centre

single quotes for fields in your data. These are added automatically added,
and lozenged if validated.
double quotes for categorical values in your data, eg ‘Region’=“America”
Brackets must follow a function
Comma must follow field or value in the function

Functions

Checks whether a condition is met and returns one value if TRUE, and another value if FALSE.

IF(logical_query,value_if_true,value_if_false)

Examples of logical queries:

'Line_of_Business'="Property"
'Region'="Americas"
'Claim'>1000000

Examples

If the Line of Business is Property, then multiply premium by 1.2. If it is not Property do nothing.

IF('Line_of_Business' = "Property", 'Premium' * 1.2, 'Premium')

Using and/or in IF statements

And statement

IF('Column 1' > 'Column 2' and 'Column 3' < 'Column 4',
value_if_true, value_if_false)

Or statement

IF('Column 1' > 'Column 2' or 'Column 3' < 'Column 4',
value_if_true, value_if_false)

Combined statement

IF((('Column 1' > 'Column 2' or 'Column 1' < 'Column 5')
and ('Column 3' < 'Column 4')), value_if_true, value_if_false)

IFERROR

Returns parameter 2 if the calculation of parameter 1 generates an error.

IFERROR(parameter_1,parameter_2)

Example

If the calculation ‘claim_amount / claim_count’ generates an error, return the value 0.

IFERROR('claim_amount/claim_count',0)