Temporary FTE

Formula

[OpenInputValueBlock]

IF (NOT (@ISUDA([Dimension("DIM_NAME_SCENARIO")], "ACTUAL") OR @ISMBR("Department General")))

IF("Employee Type" == [EmployeeType.Temporary] AND "Status" != [Status.Departed] AND"Status" != [Status.Resigned] AND "Status" != [Status.TransferOut] AND "Status" != #MISSING)"FTE";

ELSE

#MISSING;

ENDIF

ENDIF

[CloseInputValueBlock]

Description

Calculates Full Time Equivalent (FTE) for Temporary employee types.