Count return error value

AppSheet AppSheet Q&A
,
1

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

2

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:

3 Likes
3

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.

3 Likes