Hello,

I have a chart displaying average hours spent on work for several departments (TASKS.DEPT). The majority of the hours worked are by a NULL undefined apartment. The data for this department displays on the graph, which is fine. What I am trying to do is exclude a different department, let's call it Processing, from the chart.

So I put into the Select Expert the following:

{TASKS.DEPT} <> "Processing"

It does the job by taking the processing section out BUT it also removes the NULL department! Is there a way to remove Processing without the NULL department or would it be easier to convert the NULL department into a department with a value for TASKS.DEPT such as "Undefined"?

Thanks, kostya. I've tried that and it caused all kinds of errors with other formulas I don't want to touch. Is there another way?

Yes, in crystal you always need to handle the NULL conditon first.