how to add a running total by line

[davymichiels]

Hello,

I can't figure out how to make a straight table with a calculated field at the back that is the some the value in the previous line and a field value in a column of the current line...

Difficult to explain but quite easy to accomplish in excel.... see attachment; the last column should be calculated

Somebody has an idea?

thanks

Davy

[Gysbert_Wassenaar]

In a straight table you can use inter-record functions like above, below, top and bottom. If you want the value of the row above the current one you use the above function: e.g.  =above(sum(Amount)) - sum(Amount)

In the script you can use the previous and peek functions: Peek() vs Previous() – When to Use Each

[MK_QSL]

How is your raw data?

I mean what are the fields you have in your base tables.

[davymichiels]

Thanks I did not know that

Now need to combine it with if() function

-> something like:

if A3 = A2 then sum(G2+D3+F3), else sum(B3+D3+F3)

but for first line of the table, there is no line above so always B3+D3+F3

[davymichiels]

fields incoming and outgoing come directly from 1 database, linked by article nr and description to another database with current stock value.

Field 'balance' is a calculation needed to predict stock situation after known future stock movements in/out