Nulls in Crosstab?

rbuser

Hi

Null values seem to be suppressed when analysing a crosstab, rather than
included in a "count of value NULL".

As we are using the cross-tab partly as diagnostic aid for look at complex
student class allocations, can you advise how to get NULL values counted in
the cross-tab, as we nearly missed a potentially major problem this morning
from unallocated students.

TIA

Barry

--

Dr Barry Clark
Senior Lecturer & IT Systems Designer
Medical Education Unit
Wolfson Medical Building
University of Glasgow
Glasgow G12 8QQ
Tel: 0141-330-4248
Email: b.clark@clinmed.gla.ac.uk

nicocizik

Hi Barry,

Try setting the SkipNulls property of the crosstab cell equal to False. You
can access this property by right clicking over the crosstab calculation
cell and selecting Skip Nulls from the popup menu.

--

rbuser

I tried that, in every cell, but "skip nulls" is greyed out in all of them
on the pop-up menu, and so is not accessible.

What do I need to do to make it accessible?

TIA

Barry

--

Dr Barry Clark
Senior Lecturer & IT Systems Designer
Medical Education Unit
Wolfson Medical Building
University of Glasgow
Glasgow G12 8QQ
Tel: 0141-330-4248
Email: b.clark@clinmed.gla.ac.uk

nicocizik

Hi Barry,

Be sure you left click over the cell so that it is highlighted black before
right clicking. Then you should have access to the "Skip Nulls" option for
each field you drop in the crosstab.

--