Salary

Formula

[OpenInputValueBlock]

IF (NOT @ISUDA([Dimension("DIM_NAME_SCENARIO")], "ACTUAL"))

IF (@ISDESC("New Employees"))

IF ("BegBalance"->"Start Month" != #MISSING)

IF ([FiscalOffset] == 0)

IF ("Cal TP-Index">= "BegBalance"->"Start Month")"Annual Salary" * [TimeBalanceSpread];

ELSE

#MISSING;

ENDIF

ELSEIF (("BegBalance"->"Start Month" - [FiscalOffset]) > 0)

IF ("Fiscal TP-Index">= ("BegBalance"->"Start Month" - [FiscalOffset]))"Annual Salary" * [TimeBalanceSpread];

ELSE

#MISSING;

ENDIF

ELSEIF ("Fiscal TP-Index">= ("BegBalance"->"Start Month" + [NumberOfPeriodsInYear] - [FiscalOffset]))"Annual Salary" * [TimeBalanceSpread];

ELSE

#MISSING;

ENDIF

ELSE

#MISSING;

ENDIF

ELSE

IF (@ISMBR("BegBalance"))

#MISSING;

ELSE

IF (("Annual Salary" == #MISSING) OR ("Status" == [Status.Departed]) OR ("Status" == [Status.Resigned]) OR ("Status" == [Status.TransferOut]) OR ("Status" == #MISSING))

#MISSING;

ELSEIF ("Status" == [Status.LeaveOfAbsence])

0;

ELSEIF ("Status" == [Status.Maternity])

0.65 * "Annual Salary" * [TimeBalanceSpread];

ELSE"Annual Salary" * [TimeBalanceSpread];

ENDIF

ENDIF

ENDIF

ENDIF

[CloseInputValueBlock]

Description

Calculates salary for new and existing employees. Existing employees’ salary takes employee status into account.