getting rid of zeros

[draacor]

I have a chart that shows the Average Cycle Time for a range of data. It works fine but for some reason anything outside the date range im selecting is being zero'd out and shows up on the graph as a zero. I cant figure out a way to get rid of it. I cant use the select tool because there are other graphs on the same report that will get messed up if i do so. The formulas i am using are:

Critical Mean:
if {tickets.type} = 'R' and not isnull ({tickets.resolve_date})
and not isnull ({tickets.active_flag}) and not isnull ({tickets.type})and not ({tickets.priority} like '')
and ({tickets.resolve_date} >={?01StartDate}-84)
and {tickets.priority} = '1-Critical'
then 2

Critical Request Count:
if {tickets.type} = 'R' and not isnull ({tickets.resolve_date})
and not isnull ({tickets.active_flag}) and not isnull ({tickets.type})and not ({tickets.priority} like '')
and ({tickets.resolve_date} >={?01StartDate}-84)
and {tickets.priority} = '1-Critical'
then 1

Request Cycle Time:
if {tickets.type} = 'R' and not isnull ({tickets.resolve_date})
and not isnull ({tickets.active_flag}) and not isnull ({tickets.type})and not ({tickets.priority} like '')
and ({tickets.resolve_date} >={?01StartDate}-84)
and {tickets.priority} = '1-Critical'
then (({tickets.resolve_date}-{tickets.open_date})*1440)/60

 

[Madawc]

Could you use the date selection in record selection? It would speed the report, if you are not using the data for something else. It will also speed processing.

If you do need those records for other processing, a subreport for the charts might be the only solution.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10