PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [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
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 375.0224 ms
"
   4381 | 5062 | 340705 | Updated
Label

The Line Number Must be an Integer (#xx#)!

In addition to checking the general correctness of formula formatting, Formula testing in financial reports also checks whether we have entered an acceptable input in between the hashes (#) in the expression.

Thus, the reference to the value of the lines from columns A or B is subject to the regulation:

In first place Follows

A – value in line under column A (Formula 1)

B – value in line under column B (Formula 2)

 arbitrary line number, e.g., 10

Only integers make sense here, using special characters does not. In such cases, the formula test returns an error.

Posting-template formula testing is done in a similar way, except that only column A is allowed there, and column B does not exist.

Expressions that fail the Check pairs are also written out, and formula testing puts us on the problematic input so that it is easier to correct it.

33039.jpg

When we click the OK button, the program places the cursor to the point in the formula where the error occurred.

The following solution is available. Enter the correct sequence number of the line that you are referring to in the formula.

Correct Incorrect
#A31#+#A32# #A3%#
#A31#+#A32# #A3[1,2]#
#A31# #A#

 

RELATED TOPICS:

Syntax error in conditional statement

Last character of the formula is an operator!

Unknown formula error


 

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