Hi all,
I wrote a query that gives me information like this:
Claim line 1: pt name: scarecrow | doc: wizard | surgery: heart transplant | paid: 1 (1 = paid) | paid amt: $20
Claim line 2: pt name: scarecrow | doc: wizard | surgery: heart transplant | paid: -1 (-1 = returned payment) | paid amt: -$20
Claim line 3: pt name: scarecrow | doc: wizard | surgery: heart design and implant | paid: 1 | paid amt: $50
When I run just a simple count of my paid surgeries, based on the above example, I will only get 1 surgery because the wizard got paid for only 1 and the transplant was cancelled out. The question is, how do I write the query to just show the claim that was not cancelled out (claim line 3)?
Thank you in advance for your help on this question (which hopefully makes sense).