Sum True (Boolean) values

Ask for Help
1

Hello, i’d like to get the sum of the true values in a new column.

Capture d’écran 2024-02-02 à 10.01.09
Capture d’écran 2024-02-02 à 10.01.091378×146 7 KB

In this exemple, i’d like to create a new column (names Total) to get 2.

2
  • Use a Make Array column to create a single array from all 5 columns
  • Use a Rollup Column to get a count of true values from the array
3

Thanks Darren, it works.
Thanks to your answer, i had another idea, and i’ve just tried again to use Math, and now, it’s OK. The first time i tried, the boolean value were not converted as a number. Maybe i made a mistake the first time. I got now to solutions thanks to you. :pray:

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.