This discussion is archived
0 Replies Latest reply: Feb 14, 2013 8:56 AM by 991167 RSS

Essbase function

991167 Newbie
Currently Being Moderated
Can someone translate the below code for me ? The focus being the shift function in bold lines. I need to understand the logic where it is adding the merit%. Appreciate any responses.

/* Annual Salary */
"Annual Salary"
(
IF(   (@SHIFT("Status"->"Dec",-1,@RELATIVE("Years",0)) != 2) AND (@SHIFT("Status"->"Dec",-1,@RELATIVE("Years",0)) != 2) AND  (@SHIFT("Status"->"Dec",-1,@RELATIVE("Years",0)) != #missing) )
IF(@SHIFT("Merit"->"YearTotal",-1,@RELATIVE("Years",0)) != #missing)
@SHIFT("Annual Salary"->"BegBalance",-1,@RELATIVE("Years",0)) + @SHIFT("Annual Salary"->"BegBalance",-1,@RELATIVE("Years",0)) * @SHIFT( "Merit%"->"BegBalance"->"NoDivision"->"NoDepartment"->"NoEmployee",-1,@RELATIVE("Years",0));
ELSE
@SHIFT("Annual Salary"->"BegBalance",-1,@RELATIVE("Years",0));
ENDIF
ENDIF
)

Edited by: 988164 on Feb 14, 2013 8:56 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points