Other Headcount

Formula

[OpenInputValueBlock]

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

IF(@ISLEV("Employee",0) AND "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 Other employee types.