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 attendees each day (on Monday we have 147, Thursday we have 92 etc..). Is there anyway of being able to name the days between two flights: 

Land on the 19th November (Sunday), depart on the 25th November (Saturday), as such this person will be in country Sun, Mon, Tues, Wed, Thurs, Fri, Sat

And then being able to sum all mon? sum all tues? etc..
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.