Average in a Line Graph

[excalibur78]

I can't seem to get a percentage to work in my line graph. I have 2 fields I'm using: Attempts and Closed I'm trying to graph the average of Closed per day (which I have the daily part working already) as a percentage where Attempts if the max possible Closed there can be a day so if Attempts is 20 and Closed is 20 the Avergae for the day should be 100% or if Attempts is 30 for the day and Closed is 15 it should should 50%. Any help would be great.

Thanks

David Dockham

 

[kenhamady]

I am confused by the word average. Do you just want a chart of the percentage closed for each day? Do you have one record per day showing attempts and closed, or do you have one record per attempt with an indication of closed? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal