Help Centre

Equation editor
Functions in Analyse
Valid operators in the equation editor:
+
  plus

-
  minus

/
  divide

*
  multiply

^
  exponent

=
  equals

!=
  not equals

>
  greater than

<
  less than

>=
  greater than or equal to

<=
  less than or equal to
Standard syntax must be followed for the equation editor to function. Quantemplate automatically inserts correct syntax where possible.
' '

" "
IF(...)
,
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
IF
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)