I have a database where I import a csv file with multiple transactions per day into a FM database. There are several number fields that are sub totaled by date in a FM Report I created. It looks great. The problem I am having is I need to add a $20 fee per day, and have it on the report per day. So when I look at the report it has the other field totals, and one $20 fee per day. The grand totals of all the days are on the bottom of the report and I would like a grand total of the $20 fee per day.
How do I this when all my other totals are based on FileMaker records? I can’t add the $20 fee per transaction because it will be on all the records for that day.