Null count issue

[#1]

In order to make the Null values appear in list boxes and be selectable, we use the following code:

NullAsValue *;

Set NullDisplay = '<NULL>';

However, now, if we want to count the number of null elements, the nullcount function no longer works in a statistics box (it returns zero even though there are null elements). Is there anyway to fix this? Would it involve making a custom function (and how would one construct such a custom function)?

Any help would be appreciated

[Anonymous]

Stephen

This expression with set analysis should work.  [Replace [YourField] with your field name]

     =count( { <[YourField]={'<NULL>'} > } [YourField] )

Best Regards,     Bill

[iktrayanov]

One solution could be if you load your field of interest for example - Field1 twice in the script something like this

Table1:

Load

...

Field1,

Field1 as Field1_

..

NullAsValue *;

NullAsNull Field1_;

Set NullDisplay = '<NULL>';

Table2:

Load

...

Field1,

Field1_

resident Table1

[#4]

Hi Bill! This works for the pivot table, but there's I can't figure out how to include an expression in the statistics box

[Anonymous · Accepted solution]

Stephen

A bit of a bodge, but you could put that expression in a text box and the place it over the statistics box so it appears over the figure you don't want.

Or maybe you could try the suggestion iktrayanov posted.

Best Regards,     Bill