Forum Discussion

LiamBloundele's avatar
LiamBloundele
Qrew Member
8 years ago

calculating the number of people per day between two dates

Hello, I'm creating a quickbase to manage the logistics of an international conference. I would like to be able to work out which days each person is in country, so I can track the number of attend...
Ask about Quickbase functionality
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
No problem

Make a formula numeric field called [Monday Count] and make a formula which calculates to either a 1 or a 0 based on if they attended on Monday. Post back if you need help with that.

Then duplicate that field and adjust the formula for a Tuesday. And then again for each day.

Then simply run a List All type report with these fields and you will have your totals at the bottom of the report.