Create Formula Using SL Expression in Formula Builder
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:
-
without SQL expression
-
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. |