Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Stephen
This expression with set analysis should work. [Replace [YourField] with your field name]
=count( { <[YourField]={'<NULL>'} > } [YourField] )
Best Regards, Bill
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
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
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