Selection formula help please - Crystal XI 1

[jpeters01]

I need a selection formula that selects all medications where:
{PatientMedication.ROUTE} does NOT equal "FNB" and {PatientMedication.COMPUTED_FREQUENCYSIG} is NOT like *AS*NEEDED* or *PRN*. Either one or both of these fields can be null.

The formula below works EXCEPT if the {PatientMedication.ROUTE} is null and the {PatientMedication.COMPUTED_FREQUENCYSIG} is PRN.

isnull ({PatientMedication.ROUTE}) or
{PatientMedication.ROUTE}<> "FNB" and
(isnull({PatientMedication.COMPUTED_FREQUENCYSIG}) or
({PatientMedication.COMPUTED_FREQUENCYSIG} = ' ')) or
not ({PatientMedication.COMPUTED_FREQUENCYSIG} like ["*AS*NEEDED*", "*PRN*"])

Your help would be very much appreciated!

 

[lbass]

(
(
isnull ({PatientMedication.ROUTE}) or
{PatientMedication.ROUTE} <> "FNB"
) and
(
isnull({PatientMedication.COMPUTED_FREQUENCYSIG}) or
trim({PatientMedication.COMPUTED_FREQUENCYSIG}) = '' or
not ({PatientMedication.COMPUTED_FREQUENCYSIG} like ["*AS*NEEDED*", "*PRN*"])
)
)

-LB

 

[jpeters01]

That worked perfectly!!! I really tried to figure this out but don't know if I will ever get where to put the parentheses, and's and or's. Will look at your solution in the morning when I am not so bleary eyed. Thank you!