Transactions Per Date

[rlinsurf]

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

[Fei]

You can try create a summary field with average pointed to the field you want. Put it at the grand total area.

[rlinsurf]

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

[comment]

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.