Skip to main content

Rollup to Count # of fields that say "Yes"

  • April 12, 2018
  • 1 reply
  • 0 views
N

Can I use a Rollup to count the # of fields in a column that say “Yes” on a linked table?

    W

    If the field contains 'yes' or is blank, you can use a rollup with COUNTA(values) for the aggregation function.


    If the field contains 'yes', 'no', 'maybe', and so on (that is, if you’re looking for yesses among a number of possible results), you’ll need to define a formula field with the formula


    IF({Query Field]='Yes',1,0)


    and then roll up the values of that field using SUM(values) as an aggregation function.

    Reply


    Terms & Conditions