3 Replies Latest reply: Apr 8, 2011 9:52 AM by Piotr Debowski RSS

    Accumulation Problem (Bar Chart)

    Piotr Debowski


      error loading image

      Can anybody explain me why calculations from my bar chart are different from what i excpect to see ?

      I want to see current difference between years in accumulation mode. Value is correct only for first quarter.

      Example application in attachment. Any suggestions are welcome!

      Thanks, Piotr

        • Accumulation Problem (Bar Chart)

          Hi buddy,

          I guess that your informations are accumulated.
          Look on graphic properties - expression - Accumulate (on down and left of window).


          • Accumulation Problem (Bar Chart)
            Piotr Debowski

            I've found solution - more complex but working.

            I disabled accumulation option for all expressions and use Above() function to accumulate values in the same way.

            I think that accumulation option caused the problem, because calculation of expression was performed for every value of dimension (Q1, Q2..) and the results were summed.

            Expressions are not so simple as it could be using accumulation mode in chart, so if somebody know simpler solution (simpler expressions or other solution) to obtain such an effect as above, please let me know.

            File with my solution in attachment.

            Regards, Piotr