PANTHEON™ manual

 Categories
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Expand]Guides for PANTHEON
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Collapse]Getting Started
     Dictionary of terms
     First steps with PANTHEON
    [Expand]Using PANTHEON at Tecta, a fictional company
    [Expand]Instructions for Ensuring Compliance of PANTHEON with SAS
    [Expand]PANTHEON Installation
    [Expand]PANTHEON System
    [Collapse]PANTHEON Basics
     [Expand]Entering PANTHEON
     [Expand]PANTHEON windows and forms
     [Collapse]Entering data and navigating across PANTHEON
      [Expand]Records
      [Expand]Lookup Window
      [Expand]Input Elements
       Lookup List
      [Expand]Keyboard Shortcuts
       Wildcard Characters
      [Collapse]Formulas
       [Collapse]Building and Testing Formulas
        [Collapse]Formula Testing
          Using logical operator without logical expression
          Opening or closing round bracket missing!
          Opening or closing square bracket missing!
          Last character of the formula is an operator!
          Adjacent hashes!
          Syntax error in conditional statement. Correct syntax is [condition:value]
          Adjacent operators (xx)!
          Variable not enclosed in hashes (#)!
          Illegal characters: xyz
          Unknown error!
          The first character of #xx# must be a transaction type or a column mark!
          The line number must be an integer (#xx#)!
          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
         Debugging Formulas
        Using Conditional Statements in Formulas
       Insert Image
     [Expand]Instructions for PANTHEON
    [Expand]PANTHEON Help
    [Expand]Materials and Goods Movements
    [Expand]Assigning Identifiers
    [Expand]Frequently asked questions about Pantheon (F.A.Q.)
    [Expand]Archive
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Expand]Financials
   [Expand]Analytics
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Expand]PANTHEON Web
[Expand]PANTHEON Granules
[Expand]User Site

Load Time: 1205.6584 ms
print   |
Label

Adjacent Operators (xx)!

Among the constants and/or expressions that refer to data from the program, mathematical or logical operators are also used in formulas.

With that, the listed operators must not appear directly after each other in the formula:

* multiply
/ divide
> greater than – for use in logical expressions
< less than – for use in logical expressions
= equals – for use in logical expressions
\ integer division – used exclusively for length-of-service formulas
| integer division remainder – used exclusively for length-of-service formulas

 

The use of the addition (+) and subtraction (-) symbols means a change in the sign, and the two symbols can be duplicated if they are written one after the other. However, if any of the above-mentioned symbols is written in between them, there is an obvious error in the formula.

If any of the listed characters or a combination of these characters is used more than once, formula testing returns this error.

Expressions that fail the logic check are also written out, and formula testing puts us on the problematic input so we can fix it more easily. If there are several such inputs in one formula, it puts us on the first incorrect input found.

33031.jpg

Possible solution:

Use only one mathematical or logical operator between two expressions in a formula!

Correct Incorrect
#QUANTITY# * 100 #QUANTITY# ** 100

*/ 100

*+100 #QUANTITY# *+*100
[#RPrice#*0.9] #RPrice# [#RPrice#>=20:#RPrice#*0.9] #RPrice#

[#RPrice#*0.9] #RPrice#

[#RPrice#*0.9] #RPrice# [#RPrice#*0.9] #RPrice#

 

 



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