Count and compare

[Luiso_Ferrandiz]

Hi all,

I need to know if a data is repeated in my column
Datos=Table
NVela=Column -Type Text

COUNT(Datos[NVela]=[_THISROW].[NVela])>1

and I get this message
Cannot compare List with Text in (Datos[NVela] = [_THISROW].[NVela])

Something is wrong.

Usualy I use contar.si(range,criteria)

Thanks for help
Regards

[Rafael_ANEIC-PY]

Hello @Luiso_Ferrandiz_Ruiz, welcome to the community !

You could try this expression instead:

COUNT(FILTER("Datos",[NVela] = [_THISROW].[NVela]))

For reference:

help.appsheet.com

COUNT()

Number of list items

help.appsheet.com

FILTER()

Select rows of table or slice

[Luiso_Ferrandiz]

COUNT(SELECT(Datos[NVela],[NVela]=[_THISROW].[NVela]))>1

I get like this, but I will try with your idea. Thanks

[Rafael_ANEIC-PY]

Oh yes, i forgot about the comparison, my bad, it should be:

IF(COUNT(FILTER("Datos",[NVela] = [_THISROW].[NVela]))>1,"Something if its true","Something if its not")

Or just

COUNT(FILTER("Datos",[NVela] = [_THISROW].[NVela]))>1

Luiso_Ferrandiz_Ruiz:

COUNT(SELECT(Datos[NVela],[NVela]=[_THISROW].[NVela]))>1

I think they are equivalent, did it do what you intended to do?