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
      [Expand]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: 453.1248 ms
"
   20 | 3866 | 340690 | Updated
Label

Formulas

Formulas are a special type of field input. As the name suggests, they are used in calculations, based on different parameters. Formulas are used in pricing, discounts, payroll calculation, finance reports, etc.

Wherever the result is variable – calculable from data based on some mathematical formula. The basic formula syntax is the same as the mathematical formula. 

Presented in more detail below are:

Table of contents

  1. Operator
  2. Operator

1. Operator

The operator can be a constant or a value from the program. If the operator is a constant, we simply enter it.

We use the program fields by placing them between 'apostrophes''. .

Correct

Incorrect

3

3h

0,75

75%

#RPRICE#

RPRICE, #RPRICE

The fields that can be used in formulas are defined using the formula. For example, with price formulas we can only use price fields, with salary formulas we can only use salary fields, etc. Which fields we can use is specified in the instructions.

2. Operators

Operators are allowed mathematical symbols:

+ add
- subtract
* 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

Other allowed characters:

[ ] The square brackets must always be paired, otherwise the formula test returns an error (see Opening or closing square bracket missing!). They are used for delimiting conditions in logical expressions (see Using boolean expressions in formulas).
( ) The round brackets must always be paired, otherwise the formula test returns an error (see Opening or closing round bracket missing!). They are used for determining the order in which mathematical operations are performed.

 

WARNING

The formulas are calculated from left to right. The logical expression in a formula can be as deep as you like.

 

RELATED TOPICS:

Using conditional statements in formulas

Building and testing formulas

Formula testing

Debugging formulas

 


 

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