Pantheon User Manual

 Categories
 Скласти тех карту
[Collapse]User Manual for DataLab PANTHEON 5.5
  End-User License Agreement
  Uvodna beseda
 [Expand]PANTHEON Editions
 [Collapse]Getting Started
   Instructions for Ensuring Compliance of PANTHEON with SAS
   Ensuring Your Data Is Compliant with SAS
  [Expand]Installation of PANTHEON and Required Components
  [Expand]PANTHEON Help
  [Collapse]PANTHEON Basics
    Print Help Topics
    Help Elements
    Glossary
   [Expand]Window Elements
   [Expand]Main Menu
   [Expand]Input Elements
   [Expand]Toolbar
   [Expand]Taskbar
   [Expand]Keyboard Shortcuts
    Wildcard Characters
   [Expand]Formulas
    Print Setup
    Filtering and Sorting
    New Record
    Insert Image
    Delete Record
  [Expand]Assigning Identifiers
  [Expand]Materials and Goods Movements
  [Expand]ZEUS Business Intelligence System
 [Expand]Settings
 [Expand]Orders
 [Expand]Accounting with Goods and Materials
 [Expand]Value-Added Tax
 [Expand]Service
 [Expand]Customs Warehouses
 [Expand]Financials
 [Expand]Personnel
 [Expand]Manufacturing
[Expand]Datalab PANTHEON 5.5
 90632
[Expand]Pantheon RA (android POS) guide
[Expand]Довідник користувача Datalab PANTHEON Farming
[Expand]User Site

Load Time: 546.8761 ms
print   |
Label

Formulas

Formulas

Formulas

010379.gif010380.gif010381.gif010411.gif010382.gif010383.gif

Formulas are used when a value in a field should be calculated according to specified parameters; eliminating the need to do so manually. This is especially useful in financial reports, pricing, payroll, etc.

That is, everywhere where the results obtained can vary, or better put, can be calculated using a mathematical formula.

The basic syntax is simple:

 Operand Operator Operand

Operands are constants ( plain numbers) or variables from PANTHEON. Variables are entered by placing them between hashes (#).

Example:

Correct Incorrect
3
3h
0,75 75%
#MPCENA# MPCENA, #MPCENA

Variables that can be used in formulas depend on where the formula is used. For example, formulas for calculating prices can contain only variables that are related to prices. Available variables for specific formulas are explained in the related topics.

 

The following operators are available:

+
addition
-
dssubtraction
*
multiplication
/
division
>
greater than - used in conditional statements
<
less than - used in conditional statements
=
is equal to - used in conditional statements
\ integer division - used only for length of service bonus formula
| remainder of integer division - used only for length of service bonus formula

 

Other valid characters:

[ ] (square brackets) Used to delimit conditions in conditional expressions (see Conditional Statements in Formulas). There must always be an equal number of opening and closing square brackets, otherwise an error is returned (see Opening or closing bracket missing!).
( ) (round brackets) Used to define the precedence of operations. There must always be an equal number of opening and closing round brackets. otherwise an error is returned (see Opening or closing round bracket missing!).

000001.gif Formulas are calculated from left to right.
Conditional statements can have any number of levels.

Related topics:




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