Hi all, i have a problem with hiding rows. I ...

(sumawa quest) #1

Hi all, i have a problem with hiding rows. I have filtered data based on a condition and returned two result, i.e YES and NO. Both seen as the result and in many rows. My question:

How do I display only 1 row for the YES, instead of many YES rows ?

Tq.

(Aleksi Alkio) #2

You need to find another and additional evaluation like AND([ColumnA]=TRUE,[ColumnB]=“Something”)

(sumawa quest) #3

Tqvm, will try

(sumawa quest) #4

Have tried this but the result still the same: AND([VisitedSUM]=TRUE,[Visited Places]=“Yes”)

(Bellave Jayaram) #5

Looks like VisitedSUM is Yes/No datatype. If Visited Places is also Yes/No datatype, then you just need: AND([VisitedSUM],[Visited Places])

(Aleksi Alkio) #6

If you see more records than just one, you have more records where the AND evaluation gives TRUE. So… the reason is not the format, it’s the structure or the data itself.

(sumawa quest) #7

Thanks. Will try out this one.