Accumulation of values in script

[#1]

Hi

This is probably a simple one, but I'm struggling...

I have two tables. One has monthly opening balances, the other has a sum of daily transactions.

What I need to do is create a table with an opening balance, transactions and closing balance for every date.

Can anyone point me in the right direction?

Trevor

[#2]

Hi Trevor,

do you have a short example you can share?

It will be easier for us than to suggest a solution.

The following statement accumulates B as a kind of LineItemAmount.

Load A, B, numsum( B, peek( 'Bsum' ) ) as Bsum...;
creates an accumulation of B in Bsum

Rainer