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 |