0 Replies Latest reply: Feb 14, 2013 10:56 AM by 991167 RSS

    Essbase function

    991167
      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