2 Replies Latest reply on Oct 3, 2016 2:40 AM by Huseyin Seker

    Calculate index between periods. The period must be changed by parameters

    Huseyin Seker

      Hi,

      I want calculate the index, percent difference,  between periods  (Years). The years must be changed with a parameter.

      For example

      If I choose 2007 the calculation must be based on 2007=100. The years must be choosed by a parameter.

       

      (ZN(SUM([Aantal_wp])) - LOOKUP(ZN(SUM([Aantal_wp])), FIRST())) / ABS(LOOKUP(ZN(SUM([Aantal_wp])), FIRST())).

      This calculation works only if i want the difference when 2007=100.

       

      How can i change the command FIRST with a parameter. So i can change the year which = 100  example 2009

       

         

      PERIODEmployers200720082009201020112012201320142015
      20072148100
      20082360110100
      2009229510797100
      20102046958789100
      201121701019295106100
      2012212399909310498100
      20131894888083938789100
      2014180384767988838595100
      2015180184767888838595100100