Incorrect syntax of condition, correct form is [Condition:Value]
Formules can also contain a conditional expression of the form 'if - then'. In formula nomenclature, such expressions are described using square brackets, and the condition and the value of the condition are separated by semicolons: [Condition:Value] if the Condition is satisfied, then the formula should be given a Value.
The formula test expects that every Boolean expression is formatted correctly in this respect. If this condition is not met, the formula test returns an error:
Formula testing puts us on the disputed record to make it easier to correct. (If there are more than one such record in a formula, it puts us on the first disallowed record found.) There are two solutions:
1. Delete the brackets if the logical condition is redundant here. It may make sense to use plain, round brackets.
2. If the square brackets are entered correctly, the condition and the value are correctly separated by quotation marks. The use of any other character is not permitted.
| Correct |
Incorrect |
| To solution 1:
(#COLICINE# + 100) / #MpPrice#
|
[#COLICINE# + 100] / #MpPrice# |
| To solution 2:
[#MpPrice#*0.9] #MpPrice#
|
[#MpPrice#>20=#MpPrice#*0.9] #MpPrice# |
| To solution 2:
[#MpPrice#*0.9] #MpPrice#
|
[#MpPrice#*0.9] #MpPrice# |