Count specific values from checkboxes

[BergLino]

Hi,

I have some checkboxes arranged in columns (days of the week) where it contains 03 items: P (Participants) = 1, F (missing) = 1 and "-" (absent) = 0.
Below I have 3 boxes of text, where I want to make the following calculations:
Cx 01: add only all the items P and F that are selected in the column;
Cx 02: Count only those that were selected with P
Cx 03: Divide Cx 02 by Cx 01 (%)

Is there any way to do this?

[try67]

What are the names of the check-box fields? What are their export values?

[BergLino]

03 items:

P (Participants) = 1

F (missing) = 1

"-" (absent) = 0.

[try67]

You're just repeating what you wrote before...

[BergLino]

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

Can it?