Set analysis question (include null except certain values)

[#1]

What would be the correct set analysis format to select all values in a dimension including the null value except for one specific value?

I am trying count({<Reason={"*"}-{'Other'}>} but this is not selecting the rows where the Reason is null (blank).

Please help.

[Anonymous]

How about checking isnull() and update it to 0 if you need only count?? like If(Field=Null(),0,Field) as Field1

[#3]

I can't update the field to zero as count is only one of the expression. The dimension is displayed as it's values in other tables.

[el_aprendiz111]

Hi,

Dimension

count({<Reason-={'Null'}>}

script

if(len(Trim(Reason)=0,0,Reason) AS Reason_2

[Anonymous]

count({<Reason-={'Other'}>YourField)

[swuehl · Accepted solution]

Have a look at

Excluding values in Set Analysis

So it could look like

=count({<OtherField = e({<Reason={'Other'}>} ) >} OtherField)

[#7]

This works like a charm!... thanks!!!