records333
Technical User
Hello,
The end goal is to flag a patient record
If measure value is consecutive for 2 days
AND value increase >= 3 on 3rd day
AND value is sustained for 2 subsequent days
THEN FLAG
Example:
Measure Date Measure Value
20-AUG-13 5
21-AUG-13 5
[highlight #FCE94F]22-AUG-13 5
23-AUG-13 5[/highlight]
[highlight #CC0000]24-AUG-13 10 (Increase by 3 or more)[/highlight]
[highlight #FCE94F]25-AUG-13 10
26-AUG-13 10[/highlight]
27-AUG-13 5
28-AUG-13 5
I am considering a solution in Crystal using variables but I'm getting stomped along the way.
The end goal is to flag a patient record
If measure value is consecutive for 2 days
AND value increase >= 3 on 3rd day
AND value is sustained for 2 subsequent days
THEN FLAG
Example:
Measure Date Measure Value
20-AUG-13 5
21-AUG-13 5
[highlight #FCE94F]22-AUG-13 5
23-AUG-13 5[/highlight]
[highlight #CC0000]24-AUG-13 10 (Increase by 3 or more)[/highlight]
[highlight #FCE94F]25-AUG-13 10
26-AUG-13 10[/highlight]
27-AUG-13 5
28-AUG-13 5
I am considering a solution in Crystal using variables but I'm getting stomped along the way.