Here you can enter formulas in two ways:

• without specifying an SQL expression - It is the classical approach for creating formulas.

For detailed treatment see: Create Formula for Meals Allowance in Formula Builder.

• with SQL expression

For detailed treatment see: Create Formula Using an SQL Expression in Formula Builder.

By entering SQL expressions you should observe the following: SQL expression begins and ends with a delimiter ~S~ a formula can contain any number of SQL expressions an SQL expression cannot contain logical conditions ([..:..]..) an SQL expression cannot contain temp tables with only one # an SQL expression can contain variables (# ... #) #) Logical conditions can contain SQL expressions.

You can resize the window any way you want. Place the pointer on the border line (see above), left-click and hold. Then move up (to make the window smaller) or down (to expand the window). If you click the line, the formula box is displayed in the entire window. Click it again to roll back.

Variables available for salary formulas are divided into:

• Program parameters
• Average salaries
• Payroll preparation
• Variables for contributions
• Single employee
• Employment record
• Position
• Personal rating
• Evaluation
• Factor net
• Cost centers
• GE variables (only available in the GE edition)
• Subjects
• Finished work analysis (only available in the MF edition)
• Rounding

Besides numbers you can use the following operands:

Operand	Description
/	Divide by
*	Multiply by
-	Subtract from
+	Add to
C	Delete
\	Integer division -  You can also enter operand by using the shortcut Alt Gr + Q.
|	Remainder in integer division -  You can also enter operand by using the shortcut Alt Gr + W.
( )	Round brackets - Use them to define the precedence of operations. There must always be an equal number of opening and closing round brackets. Otherwise an error is returned (for more information see Opening or closing round bracket missing!).
#	You must put a hash sign in front and after each variable.
>	Greater than - used in conditional statements.
<	Less than - used in conditional statements.
=	Equal to - used in conditional statements.
	[ ]  Use square brackets in conditional statements for "If Than": Use then in conditional statements when for example Condition 1 is fulfilled than Value 1 otherwise use Else.   Square brackets - Use them to define the precedence of operations. There must always be an equal number of opening and closing round brackets. Otherwise an error is returned (for more information see Opening or closing square bracket missing!). For more information see Using Conditional Statements in Formulas).
	Let us take a look at the Round function (;). Use this variable to set number of decimal places for rounding. For detailed treatment see: Rounding.

The Pay Slip field and the Use in Formula button only appear with variables used for referencing pay slips of the previous period.

The variables in question are listed below:
 

• Del11
• Del12 
   
• Del31 
   
• Inv00
   
• Inv01
• Inv10
• Inv11
• Inv20
• Inv21
• Inv30
• Inv31
• OSMND
   

For example, to reference variable Del11 in pay slipnumber 09-P00-000006 enter it as follows:

#Del11-09-P00-000006# (the Net variable - and select a pay slip from the Pay Slip). Finally, click the Use in Formula button.

For detailed treatment see: Referencing Variables in Pay Slip from Previous Period.

To make the Contribution field and the Use in Formula button available, select Variables for Contributions on the right.

For detailed treatment see: Referencing Variables for Contributions.