Skip to Content
0

BUSINESS INTELLIGENCE: Multiple Where clauses in a Variable?

Nov 27, 2017 at 04:23 PM

20

avatar image
Former Member

I am working on a BI report where I need to create a count based on two specific items and don't know how to input two (2) where clauses in a variable.

Here is what I have so far:

=Count(([Appt Date Time]) Where [Status] = "ATTENDED") And Where(([Appt Date Time]) Between ([Vt Prim Ins Effective Dttm];[Vt Prim Ins Expiration Dttm]))

I don't know if I can make two seperate counts to get the specific items I am looking for and what I am doing wrong to get the error on the above variable.

Thank you in advance for any help you can provide.

Tp

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

1 Answer

AMIT KUMAR
Nov 27, 2017 at 04:27 PM
0

try this.

=Count(([Appt Date Time]) Where (([Status] = "ATTENDED") And (([Appt Date Time]) Between ([Vt Prim Ins Effective Dttm];[Vt Prim Ins Expiration Dttm])))

Share
10 |10000 characters needed characters left characters exceeded