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

    Count specific values from checkboxes

    BergLino Level 1

      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?