Skip to Content
0

Bracket Help

Dec 05, 2016 at 12:57 PM

26

avatar image
Former Member

I am trying to write a select criteria based off of certain details (top part of the formula), PLUS, include one person specific. The formula I currently have is:

{Resources.Subject} = "Influenza Immunization" and
{Privileges.Starting_Date}<=currentdate and
{Professional_Staff_Category} in ["ACTIVE", "ASSOCIATE", "LOCUM TENENS", "MOD-ACTIVE", "PROB-TERM", "TEMPORARY", "TERM"] and
{Privileges.Appointment_Type} = "Primary" and
{Privileges.Ending_Date} >= currentdate and
{Lookup_Sites.Site} in ["NORTHPOLE"] and

{Master.Surname} = "SANTA"

I have tried adding brackets, but each time they disappear. If someone could help me place the brackets in the correct area, I would appreciate it. I am guessing that they are disappearing because I am not placing them in the correct spot.

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

1 Answer

Ian Waterman Dec 05, 2016 at 03:31 PM
0

The select you have does not need brackets. None of your conditions are dependent on any of the others.

You would only need brackets if you had some conditional filters eg If..Then ..else

or you were trying to include some conditions with OR

You need to be more specific about what you are trying to achieve.

Ian

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

This has been extremely helpful. Thank you. I appreciate your help with this.

Stacey

0