2 Replies Latest reply: Aug 9, 2018 9:51 AM by Anil Samineni RSS

    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

      2018-08-09_16-37-58.png

       

      but i still get value of 1

      2018-08-09_16-39-43.png