Solved
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...
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
------------------------------
