How can i return 'True' if it is found anywhere in my boolean column

if i have a boolean field that contains 3 rows of ‘false’ and 1 row with value ‘true’ i would like to return a true for the user
table:
username | false
username | false
username | true
username | false

return in level:
username | true

Hey Brendon!

You can use the Max formula here to get what you would like! If you use Max([Boolean Column]) then it will return true for all the groupings that have at least one true value.

1 Like