0 Replies Latest reply: Feb 11, 2011 12:45 PM by AndreaPeretti RSS

    Select accumulated percentage

      Hi,

      the column "Current (A) / © Cum" is correct.
      carry the formulas used for each column.
      if I select a value from year -month I would get the values accumulated up to that month.

      Can you help me? Please

      example:

      if I select only month of April I would like to see only record

      A = Sum ({$<year={"$(=$(current_year))"},month={"<= $(Max_month_select)"}>} qta)

      cum(A) = rangesum([A],above(cum(A)))

       

      year-monthACum(A)Ccum©cum(A)/Cum©
      2010042,00235,0010003142,74217,48%


      year-monthACum(A)Ccum©cum(A)/Cum©
      664,34185,40059144,287636699,037479
      2010011,001,00739,830518739,8305180,14%
      20100221,0022,008001478,7946711,49%
      201003211,00233,009002153,57002410,82%
      2010042,00235,0010003142,7420647,48%
      2010053,00238,001004,4571124147,1991765,74%
      20100654,00292,003004687,5411766,23%
      20100751,62343,625004937,0063066,96%
      201008133,19476,816005239,5000169,10%
      20100947,55524,356005688,4449039,22%
      20101023,00547,359006230,5927938,78%
      20101160,61607,979006508,8603699,34%
      20101256,33664,309006699,0374799,92%