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]

Where is it shared? I don't see it?

[el_aprendiz111]

Hi,

=Aggr(RangeSum(Above(sum(price),0,RowNo())),  contract_no,start_date)

[sunny_talwar · Accepted solution]

Seems to be working? What is wrong??? PFA

[thanhphongle]

Thank you so much, finally it works !!

[sunny_talwar]

I must confess thanhphongle that I am very disappointed and discouraged (no offence to you my friend el_aprendiz111)... If you see that the only difference between the two expression (one that worked and the one that I gave initially) was the name of the fields that you were using in your chart

I gave this

vs this is what finally worked

I used the fields which you told me in your initial responses.... I am not sure if I should have been smart enough to know your fields or you should have been smart enough to replace your actual fields in the expression I gave.

On top of it, you rubbed on my face by saying "Thank you so much, finally it works!!" as if what I gave never really worked....

Anyways, I know what I have to do when I see your future posts

Best,

Sunny

[thanhphongle]

Hey Sunny Talwar, I m sorry about not giving you the right response. I know you 've help me so much so far. I was quite busy this morning, so I actually forgot to realised that you help me most in this case so far. I ll edit the post. Hope this is ok for you

[sunny_talwar]

thanhphongle‌ the intention was not to take anything away from el_aprendiz111 (in fact it would be unfair to give me the correct response after I messaged you and I would request to give it back to him). But the intention was to let you know that you need to at least acknowledge the fact that I gave you the correct response earlier, but you just didn't apply it for your case. I am not here to gather points, but to help people (not getting paid for this). But it tends to get annoying that after so much effort, people don't even want to acknowledge your contribution.

[thanhphongle]

I'm sorry about it. I'm really thankful for help. The next time I will definetly acknowledge the contritbution of people's help.