accumulated

[Anonymous]

Hello,

I have the following table where I have id, date per week and the performance value in%. i want to get the accumulated of all the weeks but that does not exceed 100%.

week	performance
04/01/2021	18%
11/01/2021	53%
18/01/2021	52%
25/01/2021	34%
01/02/2021	25%
08/02/2021	68%
15/02/2021	71%
22/02/2021	64%
01/03/2021	39%
08/03/2021	67%
15/03/2021	87%

thanks 

best regards

[negi007]

@Anonymous Can you please provide more details like on what basis you wish to calculate performance. And what you mean by not exceeding 100%. please share more details, will assist you accordingly

[Anonymous]

it is a value that I already get from a sql. But if I add every week, it happens to me 100% and I don't want that to happen. the real numbers are without the% like this: