What are the names of the check-box fields? What are their export values?
P (Participants) = 1
F (missing) = 1
"-" (absent) = 0.
You're just repeating what you wrote before...
See in the picture, the first column corresponds to the person's name.
The second column corresponds to the day of Monday and in front of each name must contain:
P of participant of the day
F of fatante, it means that it was missing that day
"-" means that on that day the person was absent and not counted.
In fields 11, 12 and 13, calculations are made, where:
11 - Expected Participants: (P + F)
12 - Total Participants: Only P or (P-F)
13 - Percentage of participants: Field (12/11)
I do not know if I could explain.
the values I had taken to try to do the calculation were:
P = 1
F = 1 or -1 (I do not know the best value for this calculation)
"-" = 0