Skip to Content
avatar image
Former Member

when i using count() the result vary

Hi Experts,

i was using count() in the first image i was getting total-504 and in second image again i'm using same variable and formula but the total vary.please suggest me where i have done mistake.

Thanks in advance,

Vinay G

capture1.jpg (25.8 kB)
capture2.jpg (19.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 08, 2017 at 06:18 AM

    Count function only count distinct values.if you add ALL in formula then it's count duplicate also.

    in second screenshot you have used ALL and it is counting duplicate values.

    Add comment
    10|10000 characters needed characters exceeded