Skip to Content
0

Report Query Conditional filters

Apr 23 at 08:47 PM

40

avatar image

Hello,

In one of the reports, I have 2 optional prompts where the users can either select ‘Yes’ or ‘No’.

Optional prompts:

  • 1.Include ABC: Yes/No
  • 2.Include XYZ: Yes/No

For example: There are 100 records in total

Others :50

ABC: 40

XYZ: 10

There can be 4 scenarios:

1.Include ABC: Yes

Include XYZ: Yes

I want to see 50 records in the report (40 ABC, 10 XYZ)

2.Include ABC: Yes

Include XYZ: No

I want to see 40 records in the report (40 ABC)

3.Include ABC: No

Include XYZ: Yes

I want to see 10 records in the report (10 XYZ)

4.Include ABC: No

Include XYZ: No

I want to see 50 records in the report (50 Others)

What I am doing in the query filter is:

Include ABC (response from user)

AND

Include XYZ(response from user)

By using 'AND', one of the scenarios (#1) is not working out.

Include ABC: Yes

Include XYZ: Yes

When the user is selecting ‘Yes’ for including ABC and XYZ, it is giving zero(0) records.

Can you please help me on how to apply the condition I query filters to get the number of records for all the 4 scenarios correctly?

Thank you!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jennifer Szulinski Apr 24 at 12:36 PM
0
Hi, Did you try using 'OR' instead of 'AND', in your first scenario?
Share
10 |10000 characters needed characters left characters exceeded
Vindhya Rani Giri Apr 24 at 02:07 PM
0

Hi, yes I tried using 'OR' . The first scenario works but the rest 3 scenarios do not work correctly if I am using OR instead of AND.

Thank you!

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

can you share a screenshot of your used filters please?

0