Create Formula Using SL Expression in Formula Builder

Do the following to create a formula for commuting allowance in formula builder (see type 4). 

The formula consists of the following:

[(#Del04#*#Fa6#*#VZRD-Dni#)+#Del05#*#VZRD-Dni#>#PRZnesek#+(#Del04#*#Fa6#*#VZRD-Dni#):#PRZnesek#+(#Del04#*#Fa6#*#VZRD-Dni#)]#Del05#*#VZRD-Dni#+(#Del04#*#Fa6#*#VZRD-Dni#)

#Del05#*#VZRDČ-Dni#+(#Del04#*#Fa6#*#VZRDC-Dni#)

The variables in formula influence the following:

When daily commuting expense is greater than the monthly expense, use monthly allowance. Otherwise use daily allowance.

This can be done in the following two ways:

1. without SQL expression

2. with SQL expression

Type 1: Without SQL Expression

To create a formula in formula builder, see Create Formula for Meals Allowance.

2Type 2: With SQL Expression

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 ([..:..]..) SQL expression cannot contain temp tables with one # SQL expression can contain variables (# ... #) Logical conditions can contain SQL expression

You can enter SQL expression in formua builder observing the above rules.

Then press and finally in order to record formula in the corresponding field in Earnings Types.

You can test formulas which do not include SQL expression in the Test panel, since SQL expressions cannot be tested in formula builder.