4 Replies Latest reply on Feb 8, 2018 1:18 PM by BergLino

# Count specific values from checkboxes

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?

• ###### 1. Re: Count specific values from checkboxes

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

• ###### 2. Re: Count specific values from checkboxes

03 items:

P (Participants) = 1

F (missing) = 1

"-" (absent) = 0.

• ###### 3. Re: Count specific values from checkboxes

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

• ###### 4. Re: Count specific values from checkboxes

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?