Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Thanks, the code below did it for me. for the extra information!
=SUM({<Rekeningnummer=, Bedrijfsnaam=, CalendarDate= '$(=Minstring(CalendarDate))'}>}OpeningBalanceAmount*DebitCreditFactor)