Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

accumulated

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%.

 

weekperformance
04/01/202118%
11/01/202153%
18/01/202152%
25/01/202134%
01/02/202125%
08/02/202168%
15/02/202171%
22/02/202164%
01/03/202139%
08/03/202167%
15/03/202187%

 

thanks 

best regards

Need Help

2 Replies

  • negi007's avatar
    negi007
    Community Champion
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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: