QS How to add accumulated line ?

[paulyeo11]

Hi All

I have a chart , which display yearly amount , i like to another line , which display the accoumulation amount.

Hope some one can help me.

In my example i have :-

+19.8

-11.7

-20

+30.8

So i wish the Accumulated amount by year will end with total amount = 20 K as shown in the left table.

In my next post i will enclosed with QS QVF file.

[paulyeo11]

Enclosed my QS QVF sample file .

Pls refer to last sheet of my Sample chart.

[swuehl · Accepted solution]

Try as second expression

=Rangesum(Above(Sum({<ExecPLStart={"176"}>}Amount/1*-1)/1000,0,rowno()))

And I don't think you need a sample file with >7 MB and 35 sheets to demonstrate your issue.

[paulyeo11]

Hi Swuehl

Many thank your expression as usual work fine.

I am sorry. I will further reduce the data.

Paul