PANTHEON™ manual

 Categories
[Expand]User Manual for DataLab PANTHEON 5.5
 No formula defined!
 Debugging Formulas
[Expand]Testing and Debugging Formulas
[Expand]Datalab PANTHEON 5.5 Guide
 Opening or closing round bracket missing!
 Opening or closing square bracket missing!
 Conditional statement at position x not enclosed in square brackets!
 Syntax error in conditional statement. Correct syntax is [condition:value]
 Adjacent operators (xx)!
 Last character of the formula is an operator!
 Variable not enclosed in hashes (#)!
 Illegal characters: xyz
 Unknown error!
[Expand]User Manual for Datalab PANTHEON Farming
[Expand]User Site
 Adjacent hashes!
 The line number must be an integer (#xx#)!
 The first character of #xx# must be a transaction type or a column mark!
 The first character of #xx# must be an operation type (R, S, O or A)!
 The second character of #xx# must be a transaction type (D, K, S, P, or O)!
 Variable not defined
[Expand]Kralicek Quicktest Financial Ratios

Load Time: 500.0042 ms
print   |
Label

Conditional statement at position x not enclosed in square brackets!

Conditional statement at position x not enclosed in square brackets!

Conditional statement at position x not enclosed in square brackets!

Formulas can contain conditional statements with the basic syntax 'if A is true, then B'. Such statements are enclosed in square brackets. See Using Conditional Statements in Formulas).

The formula test requires that all brackets are closed. If not, an error message is returned:

37014.png

The error message also reveals the position in the formula at which the operator in question is located. If there are multiple erroneous operators in the formula, the error message points only to the first one.

Clicking OK, the cursor shifts to the place in the formula where the error occurred.

Solution:

1. Delete the conditional operator if it is redundant.

2. If the operator is placed correctly, enclose it in sqaure brackets (see Using Conditional Statements in Formulas).

Examples:

Correct Incorrect
Redundant operator:

[#KOLICINA# > 20:#MpCena#*0.9] #MpCena#

[#KOLICINA# > 20:#MpCena#*0.9] > #MpCena#
Missing brackets:

[#KOLICINA# > 20:#MpCena#*0.9] #MpCena#

#KOLICINA# > 20:#MpCena#*0.9 #MpCena#

 




Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!