Help

Rollup Feature for Counting Single Select Field

Topic Labels: Formulas
2296 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Lee
4 - Data Explorer
4 - Data Explorer

Hello community, I have an issue where I have a list of people who took part in a survey, for which I have assigned gender to in a single select field.

In the next tab I have a rollup field which to bring up the number of males and then another field for females and so on. However, I cannot seem to get it to count the number of males who took part for example.

  • Is rollup correct for this?
  • I tried typing in COUNTALL(“males”), result is 1
2 Replies 2

Hi @Alex_Lee

You can’t do selective roll ups - but there is a solution…

  1. Create two formula fields in the original table, one called, say, Is Female, and the other called Is Male. Each would have a formula like IF(Gender = “Female”,1,0) (this for the Is Female field)

  2. You can then use roll up fields with a Sum(Values) option to add up the number of males and females into two separate fields.

I hope this helps.

Julian

Alex_Lee
4 - Data Explorer
4 - Data Explorer

Thank you, it is solved beautifully now, i love the IF() function now