Categories
User Manual for DataLab PANTHEON 5.5
	End-User License Agreement
	Uvodna beseda
	PANTHEON Editions
	Getting Started
		Instructions for Ensuring Compliance of PANTHEON with SAS
		Ensuring Your Data Is Compliant with SAS
		Installation of PANTHEON and Required Components
		PANTHEON Help
		PANTHEON Basics
			Print Help Topics
			Help Elements
			Glossary
			Window Elements
			Main Menu
			Input Elements
			Toolbar
			Taskbar
			Keyboard Shortcuts
			Wildcard Characters
			Formulas
			Print Setup
			Filtering and Sorting
			New Record
			Insert Image
			Delete Record
		Assigning Identifiers
		Materials and Goods Movements
		ZEUS Business Intelligence System
	Settings
	Orders
	Accounting with Goods and Materials
	Value-Added Tax
	Service
	Customs Warehouses
	Financials
	Personnel
	Manufacturing
No formula defined!
Debugging Formulas
Testing and Debugging Formulas
Datalab PANTHEON 5.5 Guide
Opening or closing round bracket missing!
Opening or closing square bracket missing!
Conditional statement at position x not enclosed in square brackets!
Syntax error in conditional statement. Correct syntax is [condition:value]
Adjacent operators (xx)!
Last character of the formula is an operator!
Variable not enclosed in hashes (#)!
Illegal characters: xyz
Unknown error!
User Manual for Datalab PANTHEON Farming
User Site
Adjacent hashes!
The line number must be an integer (#xx#)!
The first character of #xx# must be a transaction type or a column mark!
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
Kralicek Quicktest Financial Ratios

Formulas

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!).

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

Formulas

Formulas

RSS

Technical help

Membership:

Additional info