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?

jkingcrow21
Image Sensor

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

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
Akshay1
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
jkingcrow21
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
Akshay1
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