Hello,

There is any way to create a calculated field, like a cumulative total from all records, ignoring the date period?

I'll try to explain better what I want...

I have a table like this (bank account movement):

DATE | DEBIT | CREDIT
1 | 10,00 | 0,00
2 | 0,00 | 20,00
3 | 0,00 | 10,00
n | n | n


I've created a new calc field named TOTAL (credit-debit):


DATE | DEBIT | CREDIT | TOTAL
1 | 10,00 | 0,00 | -10,00
2 | 0,00 | 20,00 | 20,00
3 | 0,00 | 10,00 | 10,00

Lets suppose that DATE is a year, and I've created a new report, that just show me YEAR 3 movements/balance:

DATE | DEBIT | CREDIT | TOTAL
3 | 0,00 | 10,00 | 10,00

What I really need is another column (BALANCE) showing me the actual balance, considering YEAR 1, 2 and 3 balances:

DATE | DEBIT | CREDIT | TOTAL | BALANCE
3 | 0,00 | 10,00 | 10,00 | 20,00

or

DATE | DEBIT | CREDIT | TOTAL | PREV DATES BALANCE | ACTUAL BALANCE
3 | 0,00 | 10,00 | 10,00 | 10,00 | 20,00

I've create this in MS excel using the FILTER ALLEXCEPT function, witch sum the total balance where DATE < min(DATE):
=CALCULATE(SUM(Consulta[BALANCE]);FILTER(ALLEXCEPT(Consulta;Consulta[Conta Corrente];CONTA[Conta Corrente]);Consulta[DATE]
I'm evaluating YF 7.1. Firebird 1.5 DB (not showing date hierarchy options when creating a view).

Thank you
Henrique