topic Re: QS How to add accumulated line ? in App Development

QS How to add accumulated line ?

paulyeo11 — Sat, 27 Feb 2016 22:10:22 GMT

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 — Sat, 27 Feb 2016 22:12:09 GMT

Enclosed my QS QVF sample file .

Pls refer to last sheet of my Sample chart.

swuehl — Sat, 27 Feb 2016 23:10:08 GMT

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 — Sat, 27 Feb 2016 23:41:12 GMT

Hi Swuehl

Many thank your expression as usual work fine.

I am sorry. I will further reduce the data.

Paul