U
urbanista
I'm working with a big dataset that I want to export for
statistical use. To do this, I count records (trips) in
one table that are linked to another table (persons). The
result is a crosstab showing in the value the number of
trips by category for each person. However, I get null
values when the person took no trips in that category. I
need these null values to be zeroes for my statistical
process. Is there any way to set zero (not null) as the
default "count" in the crosstab?
Thx!
statistical use. To do this, I count records (trips) in
one table that are linked to another table (persons). The
result is a crosstab showing in the value the number of
trips by category for each person. However, I get null
values when the person took no trips in that category. I
need these null values to be zeroes for my statistical
process. Is there any way to set zero (not null) as the
default "count" in the crosstab?
Thx!