2 Replies Latest reply: Aug 28, 2012 5:39 PM by Ben Robinson RSS

    Accumulation Issue - Help required!

    Ben Robinson

      Hi all,

       

      I have an issue that I have tried numerous ways to overcome but to no avail so I need the assistance of an expert!

       

      I have chart that I am displaying as line graph and in this chart I have a value called Contract value which is a flat line across all months as the value never changes.

       

      I want to show the Balance to complete the project which is worked out by the calculation: contract value - costs to date

       

      I tried to then tick the accumulation tick box against that expression so that the costs are accumulated and hence the line should go down from left to right.

       

      My issue is that this also accumulates the contract value data. Is there a way to essentially amend my calculation so that it does contact value - accumulated(costs to date) rather than accumulating it all?

       

      This is how my chart shows when I don't tick the accumulate and you can see here it is taking off the cost of each month from the total contract value.

       

      notaccumulated.jpg

      When I accumulate the expression it then shows like this (which is not what I want because it is accumulating the contract value as well):

       

       

      accumulated.jpg

       

      I would really like it to display similar to the below graph and it is this I don't know how to acheive, any assistance would be greatly appreciated!

       

      howitshouldbe.jpg

      Many thanks

      Ben