Skip to Content
0

when i using count() the result vary

May 08, 2017 at 04:55 AM

29

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
May 08, 2017 at 06:18 AM
0

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.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Amith,

Thanks for reply

I first as well as in second i have added "all" but in second i am getting extra documents.

Once again thnaks for reply

Regards,

Vinay G

0

what is the second column in the first screenshot? values are where 000020..

add this column in the formula with foreach.

e.g.=count(sales order num;all) foreach (your object)

0

Hi amith,

Its sales order number and sales item number but i am getting still the difference.

Regards,

Vinay G

0