Crystal 8.5 Line Chart using Subset of Data

[dnsquires]

I m trying to make a line chart in Crystal 8.5 that contains 2 data series, one is a subset of the other. I want the first line on my graph to represent the average length of stay for all patients weekly. I want the other line to represent the average length of stay for patients with length of stays greater than or equal to 6. If I try to make a formula field to run this information, the field I use that only shows the length of stay for those patients with a length of stay over 6 days, it gives the patients with a length of stay that is less than 6 days a value of 0 making the average lower than that of all of the patients for the same time period when it should be higher. I hope this makes sense, any help would be greatly appreciated!

 

[Dan3D]

I don't fully understand your request, you may want to post it on the BusinessObjects:CrystalReports 4 OtherTopics forum.

You may also want to visit our website, which might have some helpful ideas.

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com

 

[lbass]

Try the following. First create a formula {@null} by opening and saving and closing a new formula wiithout entering anything in the formula area. Then use a formula for your date difference like this {@LOS}:

if datediff("d",{table.admissiondate},{table.dischargedate}) >= 6 then
datediff("d",{table.admissiondate},{table.dischargedate}) else tonumber({@null})

Use this as the second summary field, using average as the summary.

-LB