topic Re: In QV i can just click on full Accumulation. In QS , may i know how to do it ? in App Development

In QV i can just click on full Accumulation. In QS , may i know how to do it ?

paulyeo11 — Fri, 12 May 2017 11:54:46 GMT

Hi All

I am create a 8020 table.

My expression :-

Sum(sales)/Sum(TOTAL(sales))

Paul

paulyeo11 — Fri, 12 May 2017 11:55:35 GMT

my qvf

sunny_talwar — Fri, 12 May 2017 11:55:40 GMT

May be just this

RangeSum(Above(Sum(sales), 0, RowNo()))/Sum(TOTAL sales)

sunny_talwar — Fri, 12 May 2017 11:58:21 GMT

or this: RangeSum(Above(TOTAL Sum(sales), 0, RowNo(TOTAL)))/Sum(TOTAL sales)

Something like attached?

paulyeo11 — Fri, 12 May 2017 12:12:54 GMT

Hi Sunny

Now your name added Talwar !

Your expression work fine. But After i have use your expression , My table unable to sort from Hi to Lo on sales SUM ?

Paul