rlinsurf Posted September 12, 2006 Share Posted September 12, 2006 The last thing I need to do is calculate the average of transactions taking place per day. For example, if a transaction for $24, another for $4, and a third for $75 happened 3/10, and then a transaction for $31 happened on 3/11, the average per day would be $67. I'm not sure how to get this average based on dates where there can be one, some, or even no transactions on a given date. All My Best, Jeffrey Link to comment Share on other sites More sharing options...
Fei Posted September 12, 2006 Share Posted September 12, 2006 You can try create a summary field with average pointed to the field you want. Put it at the grand total area. Link to comment Share on other sites More sharing options...
rlinsurf Posted September 12, 2006 Author Share Posted September 12, 2006 Not sure I understand. An average of which field? I have a field which is an average of the transaction amount already on the layout. But this doesn't give a per-day average, just a per transaction average. All My Best, Jeffrey Link to comment Share on other sites More sharing options...
comment Posted September 12, 2006 Share Posted September 12, 2006 Add a subsummary part to your layout, defined as 'when sorted by Datefield'. Put your Datefield and the summary field in this part, and sort the records by Datefield. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6570 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now