Skip to Content
0

Count function for not same IDs from different queries

Jul 20, 2017 at 09:58 AM

23

avatar image

I've checked my logic and found some difficulties with my report.

So I've got 3 different queries.

The first query get values with some IDs

The second query get other values with some IDs

The third query get other value with some IDs

And finally I've got a table with merged IDs from all of these queries.

The problem is that IDs may be the same in all of these queries.

So I need to Count IDs but not to be same from other queriy.

And here below is my needable table

(Total IDs from Query-1 and not same In Query-2,3) (Query-1 IDs) (Query-2 IDs) (Query-3 IDs)

6 100 10 10

7 154 12 12

89 167 18 19

So my question is how to use =Count or some other function to Count Query-1 IDs wich is not same in Query-2 and Query-3 IDs ?

10 |10000 characters needed characters left characters exceeded

Hi,

Try this

=Count(ID.Query1) Where (ID.Query1 <> ID.Query2 and ID.Query1 <> ID.Query3)

If Where condition doesn't stisfy then use "IF" statement.

Thanks,

Jothi

0

Yep,

I've test its condition it's not working. I've found another way.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers