Discussions

Expand all | Collapse all

calculating the number of people per day between two dates

  • 1.  calculating the number of people per day between two dates

    Posted 10-05-2017 09:49
    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..


  • 2.  RE: calculating the number of people per day between two dates

    Posted 10-05-2017 10:20
    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.