cancel
Showing results for 
Search instead for 
Did you mean: 

I have multiple columns with true/false logic, how do I show all the trues for the columns?

Highlighted
Image Sensor
Need to display only the trues for the computation columns, however, I have 25+ columns with true/false statements
Labels (1)
0 Kudos
3 Replies
Highlighted
DC Motor
Hello Jkingcrow21 - Do you only want to keep row values where all values across all the 25 + columns that are true or do you want to filter this based on One particular column.

Thank You,
Akshay
0 Kudos
Highlighted
Image Sensor
I want to keep all the rows where the columns are true. So I cannot filter the columns, but maybe a computation would work?
0 Kudos
Highlighted
DC Motor
Yeah a compute statement that goes like 

If(And(@Col1@ = true,@Col2@ =true,@Col3@ = true),true,false)

Note: this is is an example with just three columns as true, in your case we would need to apply this formula going all the way to the 25th column that should be true.

Thank You,
Akshay
0 Kudos