Expression to count even if null

[amoslade]

I have a graph report I am creating.  I am trying to count the number of work orders assigned to individual technicians.  We have some work orders unassigned and I want those to show on the graph as well.  Here is the count statement I am using and I am wondering how to change it so null values will be included.

count ([EVT_CODE] FOR [EVT_PERSON], [Location])

Thanks for any advice!

[Lynn]

I have a graph report I am creating.  I am trying to count the number of work orders assigned to individual technicians.  We have some work orders unassigned and I want those to show on the graph as well.  Here is the count statement I am using and I am wondering how to change it so null values will be included.

count ([EVT_CODE] FOR [EVT_PERSON], [Location])

Thanks for any advice!

You can try using a coalesce function to replace the null value with text that can then be counted by the count function.

coalesce ( expression_list )

Returns the first non-null argument (or null if all arguments are null). Requires one or more arguments in "expression_list".

Code Select Expand


coalesce ( [EVT_PERSON], 'Unassigned' )


[amoslade]

I tried this with no change.