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
     First steps with PANTHEON
    [Expand]PANTHEON Installation
    [Collapse]PANTHEON Basics
     [Expand]Instructions for Ensuring Compliance of PANTHEON with SAS
     [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
       [Expand]Building and Testing Formulas
        Using Conditional Statements in Formulas
       Insert Image
     [Expand]Instructions for PANTHEON
    [Expand]PANTHEON System data
    [Expand]PANTHEON Security
    [Expand]Using PANTHEON at Tecta, a fictional company
    [Expand]Frequently asked questions about Pantheon (F.A.Q.)
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
    Creating new invoice
   [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
 [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
[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]User Site

Load Time: 1437.5372 ms
"
   2418 | 3869 | 340693 | Updated
Label

Building and Testing Formulas

The Formula Builder, which is used for building, fixing, and testing formulas, opens by clicking the Test button, and can be found wherever formulas are entered.

The following provides more details about:

Table of contents

  1. Types of variables
  2. Information about the formula
  3. Parameters tab
  4. Test tab

 

1. Types of variables

We select a variable from the Variables table to be displayed in the formula by double-clicking on it. The lower part of the Formula builder contains the descriptions of the variables we used to build the formula.

Calculator commands from the Parameters tab are also transferred to formulas.

 

2. Information about the formula

The Formula field displays the formula that is currently being used to calculate data. We can also correct it here and confirm the correction by clicking the Use button.

Clicking the Test button will calculate the data from the formula and the data will be displayed in the lower part of the Formula Builder.

3. Parameters tab

On the Parameters tab, we can enter values into the formula itself, using the calculator.

4. Test tab

Here, we test the correctness of the formulas. To get to the tab, we click the Test tab or the Check button.

Variable

 

The program writes out every single variable that we have entered on the Parameters tab.

If a variable in a formula is entered incorrectly (e.g., has the wrong formula syntax), it will not be returned (displayed) in the list of variables, or it will not be displayed in its position. This is a clear indication that the formula is wrong!

Value

 

For testing purposes, we can enter a value for each variable into this field to test the formula. This provides an easy way to check whether the formula returns the expected results. If this is not the case, the formula can be checked, modified and, if necessary, the entered formula changes can also be saved.

 

By clicking the Test button, the program displays the result of the formula test in the lower part.

HINT

For the formula testing process, see Formula testing.

For an example of how to debug a formula and write the correction into the database, see Debugging formulas.

 

WARNING

The Use button allows you to download a corrected or newly set formula into the Earnings types register, to the Formula field. In this way, the formula is entered into the register or database from where it was read, and formula testing is automatically started under the new conditions.
 

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