PANTHEON™ Help

 Toc
 PANTHEON Ajutor - Bun venit
[Collapse]PANTHEON
 [Collapse]Ghiduri pentru PANTHEON
  [Expand]Ghid pentru PANTHEON
  [Expand]Ghid pentru PANTHEON Retail
  [Expand]Ghid pentru PANTHEON Vet
  [Expand]Ghid pentru PANTHEON Fermă
 [Collapse]Manuale de utilizare pentru PANTHEON
  [Expand]Manual de utilizare pentru PANTHEON
  [Expand]Manual de utilizare pentru PANTHEON Retail
  [Expand]Manual de utilizare pentru PANTHEON Vet
  [Expand]Manual de utilizare pentru PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Ghiduri pentru PANTHEON Web
  [Expand]Ghid pentru PANTHEON Web Light
  [Expand]Ghid pentru Terminalul Web PANTHEON
  [Expand]Ghid pentru PANTHEON Web Legal
  [Expand]Arhivă produse vechi
 [Collapse]Manuale de utilizare pentru PANTHEON Web
  [Expand]Începerea PANTHEON Web
  [Expand]Manual de utilizare pentru PANTHEON Web Light
  [Expand]Manual de utilizare pentru terminalul web PANTHEON
  [Expand]Manual de utilizare pentru PANTHEON Web Legal
  [Expand]Arhivă produse vechi
[Collapse]PANTHEON Granule
 [Collapse]Ghiduri pentru granule PANTHEON
  [Expand]Granul Personal
  [Expand]Comenzi de Călătorie Granule
  [Expand]Documente și Sarcini Granul
  [Expand]Tabloul de bord Granule
  [Expand]Comenzi B2B Granule
  [Expand]Granul de Serviciu pe Teren
  [Expand]Granul Inventar Active Fixe
  [Expand]Inventar de Magazin Granule
 [Collapse]Manuale de utilizare pentru granulele PANTHEON
  [Expand]Începerea
  [Expand]Granul Personal
  [Expand]Comenzi de Călătorie Granule
  [Expand]Documente și Sarcini Granul
  [Expand]Comenzi B2B Granule
  [Expand]Tabloul de bord Granule
  [Expand]Serviciul de teren Granule
  [Expand]Granul Inventar Active Fixe
  [Expand]Inventar de Magazin Granule
  [Expand]Arhivă
[Expand]Site utilizator

Load Time: 312,5097 ms
"
   6613 | 1 | |
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!