Skip to Content
0

Crystal Formula

Nov 21, 2016 at 04:10 PM

35

avatar image

I have a report where I am trying to only pull patients that have both of the orders below. The report keeps giving me all patients, I don't think it is reading the formula correctly. What is the correct way to write this ? Thanks in advance.

If
({ORDER_PROC.PROC_CODE} in ['LAB48','LAB178','LAB2074','LAB358','LAB359','LAB48'] and
{ORDER_PROC.PROC_CODE} in ['LAB99','LAB2119'])
then true

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

2 Answers

Brian Dong Nov 21, 2016 at 09:27 PM
0

Hi Curt,

The formula is looking for any one with any of these codes. It's not looking at each set separately. So we need to separate them like:

If {ORDER_PROC.PROC_CODE} in ['LAB48','LAB178','LAB2074','LAB358','LAB359','LAB48'] Then 
     If {ORDER_PROC.PROC_CODE} in ['LAB99','LAB2119'] Then 
          True 
     Else False 
Else False; 

Good luck,

Brian

Share
10 |10000 characters needed characters left characters exceeded
Curt Othmer Nov 21, 2016 at 10:17 PM
0

I tried the formula. I have a patient that has an order in both but it comes up 'false', it should be 'true'. Am I missing something ?

Share
10 |10000 characters needed characters left characters exceeded