Count return error value

[Jimgsey]

I have a table where I add the fil that I see, with two colums

 Table= Record    
 Colum1= Year
 Colum2= Film

Now I would like to add a virtual column that print 0 if I see only one time the film or print 1 if I see more than one time.

I try it:
COUNT(SELECT(Record[Film], TRUE, FALSE))
COUNT(Record[Film])
but allways appear the number of rows I had recorded (200 rows), I only need two if [Film] appear in [Film] before… nothing more.

Thanks you so much

[Marc_Dillon · Accepted solution]

Jimgsey:

I try it:
COUNT(SELECT(Record[Film], TRUE, FALSE))

You have to make a comparison. That’s what the second argument of SELECT is for. Read through the SELECT article once more:

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Jimgsey]

Jimgsey:

COUNT(SELECT(Record[Film], TRUE, FALSE))

The rush is not good, I was so confused that I didn’t realize it, you were right, the condition to be met was missing. Thanks a lot.