Hey Guys!
Long time!

I'm currently working on this report in which we're trying to basically give a score to our patients based off medications and living status.

Lets just say medications are x, y and z.
And Living statuses are a, b and c

Each of these has a forumula that counts if a patient falls under any of these values.

Formula for "x"
if {medication.brand_name} in ["series of medications that fall under x category"] then
    1
Else
    0
The others follow this same forumla.

so basically what i'm trying to do is something like...
shared numbervar Score := 0;

Sum ({@x}, {@Patient Name}) > 0 then

Score := Score + 1

Sum ({@y}, {@Patient Name}) > 0 then

Score := Score + 1

continuing on.
So for each category they have at least 1 value for.
They gain 1 point to their score.

I'm trying to avoid using an if else statement because it'll force me to create a large array of possibilities. And if I create it in an incorrect order it'll miss some values giving an improper score.

Anyone have any thoughts? My brain seems to be shut down today >.<

Thanks in advance for any help/ideas!
-Takesen

edit: Still using CRXI R2




Edited by Takesen - 05 May 2010 at 8:16am

Alright,
so say a person is on Methadone.
that alone gives that person a value of 1.

if they are on an opiate medication (the formula has a series of opiates to review) the person gets an additional point.

Score now = 2.

If they are homeless add 1

Score now = 3

ect.

The formulas tracking if they have any are as posted in previous post.
And I'm using the Sum grouped by person.

Thus if it's a value > 0 it's a point. We are not giving them a point PER med just per category of med.

there score for the final result needs to be a Number. so basically saying a high number score needs to be addressed.

Does that make more sense?

Well now I feel kinda silly for not thinking about doing that... I'll see what I can do when I step back into the office.

Bah, Never I'll just make them export it.