Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Have a look at
Excluding values in Set Analysis
So it could look like
=count({<OtherField = e({<Reason={'Other'}>} ) >} OtherField)
How about checking isnull() and update it to 0 if you need only count?? like If(Field=Null(),0,Field) as Field1
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.
Hi,
Dimension
count({<Reason-={'Null'}>}
script
if(len(Trim(Reason)=0,0,Reason) AS Reason_2
count({<Reason-={'Other'}>YourField)
Have a look at
Excluding values in Set Analysis
So it could look like
=count({<OtherField = e({<Reason={'Other'}>} ) >} OtherField)
This works like a charm!... thanks!!!