10 Replies Latest reply: Jul 30, 2012 9:11 AM by aholabach RSS

    accumulation in a diagram

      Hi,

       

      I have different values for each week and want to accumulate them. I tried it with the accumulation button and with the formula

       

      =

      rangesum(sum(VerfügtMore), above([Verfügt IST]))

       

      I get the same result by both (picture the blue and the light green line)

       

      Is it possible, that the line isn't over the whole x-Axis? only there, where I have accolulated values?

      so that they ends at the value 25?

       

      thanks

        • Re: accumulation in a diagram
          Stefan Wühl

          Not sure if I've understood.

          What do you mean with 'where I have accumulated values'? Do you mean something like where sum(VerfügtMore) is above zero?

           

          Try maybe something like

           

          =if( sum(VerfügtMore) <>0, rangesum(sum(VerfügtMore), above([Verfügt IST])), NULL())

           

          or

           

          =if( WeekField <=25, rangesum(sum(VerfügtMore), above([Verfügt IST])), NULL())