Skip to Content (Press Enter)
UserImage.jpg
Nader Meschi
257Views
2Comments
How can I calculate this formula in outsystems??!
Question
Beginner
Service Studio
Traditional Web
Service Studio Version
11.10.13 (Build 39571)

Hello again, 

I'm trying to calculate this formula that I had on Excel (see picture below). The first value of the column "EBIT kummuliert" should be the value of cell E2 to have an initial value for the further calculation. The next coming values of the column "EBIT kummuliert" should be calculated with the previous value of the same column + the value of the same row but different column and so on. I'm already trying hours on this. Should I do that with an aggregate or assign this?

Thank a lot in advance. :)




Cheers, 

Nader

0
0
07 Sep 2021
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi Nader,

SQL (and hence Aggregates) return data per row, and all rows are independent of each other (hence you can sort results without the results changing). So there's no way to do what you want with any type of database query. So your only options is to calculate the running total after you've queried the data.

2
0
07 Sep 2021
Copy Link
2021-09-21 09-26-31
Aadhavan Shanmugam
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.