Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Formula Problem

Status
Not open for further replies.

golden1

Technical User
Sep 16, 2008
14
GB
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??
 
Try suppressing the section where you're displaying the data when the balance is 0.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
I've tried supressing the details section where the 0.00 balance is displaying, but this then shows all transactions including 0.00 balances. I think this could be because this section is also set to only show the maximum date balance? Any other suggestions gratefully received!

Thanks

 
What is the formula you're using in your suppression?

Also, if you sort descending by date, you don't have to look for the max date. You can group by account and put the balance info in the account group header instead of the details. Suppress the details section so that it never displays. Since the most recent date will be the first one because of the sort, that's the data that will appear in the header.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top