I am making a monthly parameterized report of work orders opened for each Department. I am using the field CLSDBY to do a count of WOs by each technician. When a work order has yet to be closed in the month for which I am reporting the CLSDBY field is NULL. This is messing with the results as I have a blank in the technician list with the count of Tasks that are still open.
I would like to force the String “Open” for the work orders that have not been closed. Can anyone give me a hand with this?

Thanks in advanced.

Try this:

1. Create a formula that looks something like this:

{@WO}
if IsNull({CLSDBY}) then 'Open' else {CLSDBY}

2. Count the formula instead of the field.

-Dell

To DBlank,

Hey, thanks for the reply. I have it figured out.