0 Replies Latest reply: Jun 19, 2013 10:52 AM by Bas van Maren RSS

    accumulation in graph

      Hello,

       

      I'm trying to create a graph that uses another expression. This works fine in the straight table and provides me with the right data, however when converting this to a graph and not wanting to see the expression I required to get the index number I run into trouble.

       

      I accumulate the periodic turnover by week or period. and then divide it by the acumulated turnover of the previous year.

       

      This creates an index development of 2 seperate years

       

      ((sum({<KA_SUJaar={$(=year(today()))}, table_code = {2} >}omzet)) + if(rowno()=1,0,above([Cum huidig jaar])))
      /
      ((sum({<KA_SUJaar={
      $(=year(today())-1)}, table_code = {2} >}omzet)) + if(rowno()=1,0,above([Cum huidig jaar -1])))
      *100

       

       

      Hope anyone has a solution for me. We are using an extensive database therefore creating datapoints in the script is not preferred ( or even not an option)

       

      Thanks for your help!