Does anyone know of syntax that will allow me to supress nulls on a dimension, but include all values in an expression? I have "Category=" (where field is the dimension where nulls are suppressed) in my set analyses, but it is still excluding null values in my calculations. Thanks!
Hi there, set analysis by default excludes all null values from the result, I will advice you to change those null records to some other values like 0 or empty string '', so you can filter them correctly in set analysis expressions.
