The following are some practical examples to illustrate the types of formulae you can set up:

  1. Derives the amount for this pay element by picking up the current period amount held in pay element 2000.

Complex Formula:

a

Operand Values:

Seq

Ref

Value

---

---

====

001

a

TA[2000]

  1. The employee’s pay element amount, units or rate value is multiplied by the number of weeks in the pay period.

Complex Formula:

*a

Operand Values:

Seq

Ref

Value

---

---

====

001

a

WIP

  1. Calculates the amount payable depending on the employee’s FTE (proportion of hours worked). For example, if the full-time amount for the pay element is £10,000, but the employee only works half the time (FTE = 0.5) the system multiplies 10000 by 0.5 to give a salary of £5,000.

Complex Formula:

*a

Operand Values:

Seq

Ref

Value

---

---

====

001

a

FTE

  1. Adds the current period amounts for pay elements 1001, 1002 and 1003. It then divides that by the sum of the units in pay elements 1004 and 1005 to form a rate which is then multiplied by one and two-thirds.

Complex Formula:

((a+b+c)/(d+e)*f

Operand Values:

Seq

Ref

Value

---

---

====

001

a

TA[1001]

002

b

TA[1002]

003

c

TA[1003]

004

d

TA[1004]

005

e

TA[1005]

006

f

1.6667

  1. Assigns a different bonus to employees according to the pay band they fall into. Component ‘a’ represents pay element 1000, which gives their earnings for the current pay run. If their earnings in the pay run are less than £1,000, they receive the bonus linked to temporary pay element 9000. If their earnings are between £1,000 and £1,500, they receive the bonus linked to temporary pay element 9001. If their earnings are £1,500 or more, they receive the bonus linked to temporary pay element 9002.

Complex Formula:

If a < 1000 then b endif

If a > = 1000 and a < 1500 then c endif

If a > = 1500 then d endif

Operand Values:

Seq

Ref

Value

---

---

====

001

a

TA[1001]

002

b

FA[9000]

003

c

FA[9001]

004

d

FA[9002]

  1. A practical example to illustrate the use of UA (unadjusted) references in formulae.
  2. Assume that a current period amount of £24,000 has been assigned to pay element 1000, and its formula is /ADT.
  3. The window below has been displayed from a different pay element, whose formula refers to pay element 1000. The amount derived by the formula shown below is £12,000, i.e. 24,000 / 2. The UA reference causes the formula on pay element 1000 to be ignored.
  4. To compare the effect of not using an unadjusted reference, if the pay element FA[1000] is substituted for UA[1000] in this example, the resulting value is £1,000:
  5. a = £24,000 / ADT (12 monthly periods) = £2,000
  6. b = 2
  7. a/b = £1,000

Complex Formula:

a/b

Operand Values:

Seq

Ref

Value

---

---

====

001

a

UA[1000]

002

b

2

003

c

004

d