Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Point Flags for consecutive days with If Statements

Status
Not open for further replies.

records333

Technical User
Mar 16, 2012
41
US
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.



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top