Креирај формула Користејќи SL Израз во Градител на Формулата
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. |