On Sabbatical Headcount

Formula

[OpenInputValueBlock]

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

IF("Employee Type" == [EmployeeType.Regular] AND "Status" == [Status.OnSabbatical])

1;

ELSE

#MISSING;

ENDIF

ENDIF

[CloseInputValueBlock]

Description

Calculates Headcount for Regular employee type with a Status of On Sabbatical.