Formula Editor validation errors


The following are errors you might encounter while using the Formula Editor.

Error

Description

Examples

Unexpected [token_type]

For example, Unexpected operator

The formula contains a function component in an unexpected location

= 5=/1

= (5+1)2

Unbalanced parentheses

The formula contains an opening or closing bracket without a corresponding bracket

= 5+1)

Missing end of function

The formula contains an unclosed function

= SUM{[Item1.Points], [Item2.Points]

Unexpected function end

The formula contains a closing bracket for a function that does not relate to a function

= [Item1.Points]/2}

Invalid number of operator parameters

The formula contains an invalid number of operator parameters

= [Item1.Points] +

Invalid number of function parameters

The formula contains an invalid number of function parameters

= SUM{}

= IF{[Item1.Points]<2,5}

Numeric value expected

A Boolean statement or operator was entered in place of a numeric value

= IF{5<2,1 OR 1,4}

= SUM{1 = 2,3,4}

Boolean value expected

A Boolean statement was not entered for a condition

= IF {MIN{4,5},100,0}

= NOT{4}

Invalid terminal

The formula contains an incorrectly used terminal

= [Item1.Points] + 3.2.5