Accumulation per invoice number

[thanhphongle]

!Hello Community,

is it possible to define the accumulation per invoice number?

Example

invoice_no	payments	accumulation
1	10	10
1	20	30
1	30	70
2	100	100
2	200	300
2	300	700

This is what QV returns when I set the accumulation active in the expression tab

invoice_no	payments	accumulation
1	10	10
1	20	30
1	30	70
2	100	170
2	200	370
2	300	770

[sunny_talwar]

Try using an expression like this

RangeSum(Above(Sum(payments), 0, RowNo()))

I am assuming that you have more than 1 dimension in your chart because how else will you see repeated invoice_no

[Anil_Babu_Samineni]

Perhaps this

RangeSum(Above(Sum(payments), 0, RowNo(TOTAL)))

[sunny_talwar]

I don't think TOTAL is needed within RowNo() here

[thanhphongle]

It still continues to accumulate in a recursive way through all invoice number

[thanhphongle]

I mean it doesnt restart the accumulation for the next invoice numeber

[sunny_talwar]

What all dimensions do you have in your chart?

[thanhphongle]

invoice_no and start_date
I added the expression dual(invoice_no, start_date) in the dimension, so i can see duplicated invoice numbers, as every invoice number has another payment

[sunny_talwar]

May be this

Aggr(RangeSum(Above(Sum(payments), 0, RowNo())), invoice_no, start_date)

[thanhphongle]

I shared my qv-file to you !