Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
How is your raw data?
I mean what are the fields you have in your base tables.
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
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