problem - Count present 1 even when the table is empty

[gal_polak]

Hi,

I'm trying to do a simple count, but i noticed that when i have not data in the table, the count present value of 1

when i do have data in the table everything works perfect.

What am I missing??

I tried all of those scripts, but non of them worked:

1. Count(distinct ChallengeId)

2. Count({<[Challenge Status]={'Active'}>} distinct ChallengeId)

3. if(isnull(ChallengeId),0,count(distinct ChallengeId))

as you can see the table is empty

but i still get value of 1

[sibin_jacob · Accepted solution]

all the tables are empty or only the "Challenges" table?

as it is a key column, it will show value, if any of the one table having records.

can you check count for an another column in the "challenges" table.

For ChallengesChallengeId column:

Count(distinct ChallengesChallengeId)

[Anil_Babu_Samineni]

Take entire fields in table and show the image?