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



      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