Search results for query: *

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...

I inherited a report and I'm learning about variable. I would like assistance of interpreting and recommendations on how to refine: Extending code that uses a string fieldglobal stringvar a1cvalue := {table.LAST_VALUE}; if mid ({table.LAST_VALUE},4,1) = "-" then a1cvalue :=...

Hi Charily, Placing a max formula in the group is working. However, the report is showing null values in each formula group; 3-6M, 9-15M, etc. How should the report be coded to remove the null values? I tried the following; Standalone Formula IF {lab.RESULT_DATE} in [DateAdd("m", 3...

Hi Charliy, I tried that as well and it works if I have 1 field. But I created fields using formulas for;3-6M,9-15M and 21-24M. If I group then sort, it doesn't work across the field. What is the best way to upload an example. Copy and paste not working.

Hi Pete, Your last recommendation was my first attempt and records during the specific time frame did return. Additionally, I added IF statements to group timeframes in columns; 3-6M, 9-15M, and 21-24. However, I am stumped on how to capture the last date and last value (2 different fields)...

Thanks Pete, adding the code in the Group selection worked! ] In addition I would like to capture the following; {DATE.LAST_DATE}in [DateAdd("m", 9, {RESOURCE.LAST CLASS}) to DateAdd("m", 15, {RESOURCE.LAST CLASS})] {DATE.LAST_DATE}in [DateAdd("m", 21, {RESOURCE.LAST CLASS}) to DateAdd("m"...

I developed a report that displays the correct date ranges and values with consideration of the code in the Selection Criteria. And I created fields using If statements to capture pre and post dates. I am stumped when I attempt to select only the max date and correlating value in ID group.

Selection Criteria: ( //PRE A1C {ORDER_RESULTS.RESULT_DATE} in [DateAdd("m", -6, {ICIC.1ST CLASS}) to {ICIC.1ST CLASS}] ) or ( //POST A1C {ORDER_RESULTS.RESULT_DATE} in [DateAdd("m", 3, {ICIC.LAST CLASS}) to DateAdd("m", 6, {ICIC.LAST CLASS})] ) What is the best way to proceed with creating...

Scenario: 1)capture lab values and dates 6M before class 2)lab values and dates 3-6M after class. My selection criteria is coded to capture date 6M before or after class. Additionally I would like to create columns pre a1c values and post alc values. (report is grouped by patient) I used a if...

I modified report to the following: IF ( ({Command_DATE} in DateTime (2013, 07, 01, 00, 00, 00) to DateTime (2013, 12, 31, 00, 00, 00) AND {Command_ORDER.DESCRIPTION} like "XXX*" ) OR ({Command_CLASSES.DATE} in DateTime (2013, 07, 01, 00, 00, 00) to DateTime (2013, 12, 31, 00, 00, 00) and...

During validation, I've notice that the formula is only evaluating the first statement not the OR STATEMENTS. Please see example: IF ( ({Command_DATE} in DateTime (2013, 07, 01, 00, 00, 00) to DateTime (2013, 12, 31, 00, 00, 00) AND {Command_ORDER.DESCRIPTION} like "XXX*" ) OR...

During validation, I've notice that the formula is only evaluating the first statement not the OR STATEMENTS. Please see example: IF ( ({Command_DATE} in DateTime (2013, 07, 01, 00, 00, 00) to DateTime (2013, 12, 31, 00, 00, 00) AND {Command_ORDER.DESCRIPTION} like "XXX*" ) OR...

Hi there, Group 1 - by Location Running Totals: Patients Newly Diagnosed CLASS RESOURCE VIDEO RESOURCE CC RESOURCE The last piece is TO create a formula to count patient if they had at least 1 of the resources to reflect patient was a program particpant

I have three formulas that count if a patient attended resources A, B, and C. My goal is to count the patient once IF they attended at least 1 of the resources. I would like feedback on the best way to count the patient once.

Sorry for delay in response. It worked! Thanks a mill!

Goal: Identify patients that have upcoming appointments Monday through Friday from rundate (on Thursday). I used a dateadd formula {PAT_ENC.APPT_TIME} in dateadd('d',8,CurrentDate)to CurrentDate to capture appointments within the week of runtime. But user would like a list of appointments...

Hello All, I thought I nailed the code but records that I know should return aren't. My goal is to capture appointments scheduled 8 days from currentdate; {table.contact_date} in dateadd('d',8,CurrentDate)to currentdate

The objective is to capture patients diagnosed during a specific time frame and assigned to a specific location: Conditionsif ({CLARITY_LOC.LOC_ID} in [99999] and ({DIAGNOSIS.DATE} >=date (2012, 11, 30)) ) then {DIAGNOSIS.DATE} else if ({CLARITY_LOC.LOC_ID} in [88888] and...

I have a smiliar goal: I have a group by location that captures patients' newly diagnosed date with 250.**. I would like to capture the minimum date for each patient as mulitiple dates are referenced due to multiple dx. Any tips.

It worked, thanks a mill!