Need to Accumulate the Cost in the expression itself

[sunil2288]

Hi All,

I have Approved Amount and Cost values. But i need the Accumulated Cost month on month (if the value for Cost for a month does not exist then the previous existing value like shown in the figure).

Here you can see for 201207 Cost is 393, so accumulated cost is 393.

for the month 201208 Cost is 9, so accumulated cost is 393+9=402.

for the month 201208 Cost is 132, so accumulated cost is 402+132=534.

..

..

and for the month 201302 Cost is -109 , though the cost for 201301 doesn't exist still the accumulated cost is 2133+(-109)=2024

similarly for the month 201404 Cost is 109 , though the cost for 201403 doesn't exist still the accumulated cost is 2144+109=2253.

Any help is be highly appreciated.

Thanks friends

Sunil Kumar Panda

[swuehl · Accepted solution]

You can try enabling full accumulation option on chart properties - expression tab, or use an expression like

=rangesum(above( sum(CostField),0,rowno() ))

[sunil2288]

Thanks Swuehl..

Thanks for all your help .. Your solution worked out..