Temporary Headcount

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)

1;

ELSE

#MISSING;

ENDIF

ENDIF

[CloseInputValueBlock]

Description

Calculates Headcount for Temporary employee types.