# 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

------------------------------