Using Crystal XI
I need to exclude any instance of records with TAB; thought a simple IF statement would work, but did not.
My data to exclude looks like this:
Zocor (25mg) TAB
Synthroid (.01mg) TAB
Using Crystal XI
I need to show only records that have 6 or more dates of services. Sounds easy....Suggestions?
John Smith
Date of Discharge 7/30/09
Dates of Service
1/1/09
2/1/09
3/1/09
4/1/09
5/1/09
6/1/09
Susie Que
Date of Discharge 5/1/09
Dates of service
2/3/09
4/2/09
This should be simple but I continue to get errors.
Using Crystal XI
My data looks like this (very simplistic)
47 48 49
Yes NO Yes
NA YES YES
Yes NO NA
NO NO YES
YES YES NA
What I need is a formula that will count all YES...
I'm using Crystal XI and having difficulty creating a formula total. I've probably made this more complicated than it needs to be but because of all of the different codes, thought it was the way to build this one.I'm attempting to add up for each provider on each page their total dollar amount...
Using XI -
My data looks like this
Patient# PatientName Text
12345 Tom Smith Closed by HARPER
12345 Tom Smith Closed by TURNER
12222 Anita Baker Closed by GRAHAM
These are all patients of HARPER, but contain notes by various providers. In trying to...
I'm using CR XI. I need to report only patient records that contain services dates prior to 11/2006 but are also current patients being seen in 6/2007.
I'm grouping by patient number -
Patient # Date of Service
146097 3/2006
7/2006
4/2007...
Using Crystal XI
Data is grouped by Provider, then by patient number.
I need to refine the following data:
Patient Name Date of Service Note
Tina Smith 10/15/06 Voucher Note
Tina Smith 10/25/06 Closed Case
Tina Smith 11/05/06 Transfer Case
Frank...
I'm using Crystal X1 and a relative new user. Working off of an excel P&L statement worksheet imported to Crystal. Data looks like this -
Actual Description YTD
100 Visits 500
125.00 Gross Revenue 10,000
100.00 Net Revenue 8,000
The formula I need to...
My data looks like this grouped by provider initials:
JLJ
Patient # Appointment Date Amount
12345 4/23/07 $100.00
67890 4/23/07 $125.00
12345 4/27/07 $100.00
-------...
Our office is set up by specific groups of clinican that report to different supervisors. My data looks like this -
Number Appointment Resource Balance
1234 3/21/07 GLR $120
456 3/21/07 JPL $50
001 3/22/07 ASA $75...
My data looks like this -
Service Date Patient Number Encounter Number
2/15/06 1234 6789
3/07/06 1234 8821
4/06/06 1234 9521
1/09/06 4321 1535
2/05/06 4321 7528
Wanted Results -
4/06/06...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.