Setting zero as the default value in a crosstab

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top