Missig count

[Chanty4u]

hi all,

I have small issue

3expressions i have like below

=count(records)      500

=count({<Status={'complete','incomplete'} >}Record)      400

=count({<Status -={'complete','incomplete'} >}Record)     95

here is the issue  comes

when i club the exp 2&3   i need to get 500 records but my result showing 495 only.... where am missing  remaining 5 recors?

can anyone help me out on this?

Best

chanty

[Chanty4u]

yeah.

but  i found the issue is we have one date field   for that missing 5records doesnt have date ..

how to find that 5records  in set expression?

[vinieme12 · Accepted solution]

something like below should work

Date = {"=len(Date)<1"}

[Chanty4u]

is this work in set expression or we need any if condition prior to this?

[vinieme12]

You can directly place it in the Set

[Chanty4u]

Okay .Thanks

Best

Chanty