Need check of expression

[#1]

Hi Community,

I got the following Code:

=SUM({<Companyname = , TransactionDate = {">=(=MIN(TransactionDate)$<"} OpeningBalanceAmount)

Should display the openingsamount of the first TransactionDate

=SUM({<Companyname = , TransactionDate = {">=(=MAX(TransactionDate)$<"} ClosingBalanceAmount)

Should display the closingamount of the lastTransactionDate

What is wrong with the code? It keeps returing empty.

[Gysbert_Wassenaar · Accepted solution]

Try these:

SUM({<Companyname= ,TransactionDate={'$(=MIN(TransactionDate))'}>} OpeningBalanceAmount)

SUM({<Companyname= ,TransactionDate={'$(=MAX(TransactionDate))'}>} OpeningBalanceAmount)

And make sure your TransactionDate field contains real dates (i.e. numbers, optionally formatted as dates) and not strings.

[#3]

Thanks, the code below did it for me. for the extra information!

=SUM({<Rekeningnummer=, Bedrijfsnaam=, CalendarDate= '$(=Minstring(CalendarDate))'}>}OpeningBalanceAmount*DebitCreditFactor)