AnsweredAssumed Answered

Summary report sorted by days and a single fee per day

Question asked by swillette on Apr 9, 2018
Latest reply on Apr 9, 2018 by philmodjunk

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.

Outcomes