Departed Headcount

Formula

[OpenInputValueBlock]

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

IF("Employee Type" == [EmployeeType.Regular] AND ("Status" == [Status.Departed] OR "Status" == [Status.Resigned]))

1;

ELSE

#MISSING;

ENDIF

ENDIF

[CloseInputValueBlock]

Description

Calculates Headcount for Regular employee type with a Status of Departed.