How can I add values from the last row in 3 others columns to the value of first column
I currently have a straight table with (dummy) financial data. It has the dimensionJaarWeekand 4 expressions:
The start value ofSaldo liquide middelen bij(liquid assets) is 30.0. What I need to do is starting at 30.0 and add all of the values of the three other columns to it and put the new value for liquid assets below the first value. Then add the three values in that row to liquid values and so on. To clearify, I hardcoded the table for the correct output of the calculation:When I use the expression =NUM#($(startsaldoLiquideMiddelen), '0.0') + (NUM#([Verwachte betalingen debiteuren Af:], '0.0')) + (NUM#([Geplande betalingen crediteuren], '0.0')) - (NUM#([BTW-afdracht Belastingdienst:], '0.0')) for Saldo liquide middelen bij, I get the following incorrect table:
I also tried to use the ABOVE() function to add the values of the row above the current row. In the first case this would be null and keep liquid assets on 30 for the first row. My ABOVE expression is:
=NUM#($(startsaldoLiquideMiddelen), '0.0') + ABOVE(NUM#([Verwachte betalingen debiteuren Af:], '0.0')) + ABOVE(NUM#([Geplande betalingen crediteuren], '0.0')) - ABOVE(NUM#([BTW-afdracht Belastingdienst:], '0.0')) and this results in the first table as posted.
How can I perform this calculation correctly? I don't want to do this in the script but in the straight table itself.
The variable $(startsaldoLiquideMiddelen) is declared as SET startsaldoLiquideMiddelen = 30