Plan Departure

Description

Lets users plan for an employee’s departure.

Formula

SET AGGMISSG ON;

FIX ([Scenario], [Version], [Employees],  [Department], [Year], @LEVMBRS("Period", 0), "Local", "HSP_InputValue")
"Action" 
(
	IF  ("Fiscal TP-Index" > [Month]->"Fiscal TP-Index")
		"Action" = #MISSING;
	ELSEIF  ("Fiscal TP-Index" == [Month]->"Fiscal TP-Index")
		"Action" = [Action];
	ENDIF
);
CALC DIM ("Account");
ENDFIX