Formula to Calculate percentage based on Checkmarks and dates
Hello,
I need some help. I need to generate a Percentage based on How many times a member joins a meeting per year. I have each attendance as a simple checkmark and then another field for a date. We have various types of meetings some are only like twice a year or the most we have is 11. Each record is per person so I have dates filled and just if they attended or not. Is there anyway to make quickbase know Which meeting is the last and make that a number to use to add to a formula to calculate a percentage? How would I write a formula where I could have the total number of Checked Attendance/ by the Maximum number of meetings per year. Like have one record have 7 meetings and the person only attended 5 and have the field with the formula generate 71%. but then the next record have 5 meetings and have only 1 meeting and have the field with the formula automatically generate 20%?
Or does this have to something that Has to be manually done because the records can vary too much?
Have attached screen shot for better visualization. I hope I explained well enough but let me know if you need further clarification.
------------------------------
Maritza Acosta
------------------------------
The formula would look like this:
var number MeetingCount =
Count(
not IsNull([Date 1]),
not IsNull([Date 2]),
etc ...
not IsNull([Date 11]);
var number AttendedCount =
Count(
[Attended Date 1],
[Attended Date 2],
etc ..
[Attended Date 11]);
IF($MeetingCount >0, $AttendedCount / $MeetingCount)
// don't want to try to divide by zero.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------