Skip to Content
Former Member
Nov 27, 2017 at 04:23 PM

BUSINESS INTELLIGENCE: Multiple Where clauses in a Variable?

43 Views Last edit Nov 27, 2017 at 04:26 PM 2 rev

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.