Data Point Flags for consecutive days with If Statements

[records333]

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.