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
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.