Skip to Content
avatar image
Former Member

BUSINESS INTELLIGENCE: Multiple Where clauses in a Variable?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 27, 2017 at 04:27 PM

    try this.

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

    Add comment
    10|10000 characters needed characters exceeded