I have written a report to show bank balances of accounts. I only want to show the most recent transaction, therefore showing only the current balance and not all transactions. I have added a formula
Maximum ({Date},{Account})
This works and displays only the latest balance based on the date.
The report is also showing 0.00 balances which i want to suppress. Using the select expert doesn't work because it suppresses all 0.00 balances but then shows the next latest date balance that is not 0.00.
How can i get the report to supress the zero balance without then displaying the next latest balance that is not zero??
Maximum ({Date},{Account})
This works and displays only the latest balance based on the date.
The report is also showing 0.00 balances which i want to suppress. Using the select expert doesn't work because it suppresses all 0.00 balances but then shows the next latest date balance that is not 0.00.
How can i get the report to supress the zero balance without then displaying the next latest balance that is not zero??