If value is null

[#1]

Hi,

I want to aradictae any null values in my dashboard, I have used the supress value when null option on the charts and tables, but I have text boxes with formulas/sums in the displaying information. These still include the null values.

I want it to say something like if specialty is null then 0 else sum funded equivalent. This is the coe I have at the moment. I don't know how to make sure if specialty is null then don't sum it...

=sum({<operation_type={'Elective'}>} funded_equivalent)

Please can you help?

Thanks,

[#2 · Accepted solution]

There are two ways for it.

If you don't want to sum values if a spesific dimension value is null.

Then;

SUM( {< ColumnName = {"*"} >} Values )   > if you use "*" for a field in set analysis it eleminates null values

Also;

SUM( IF( Isnull( ColumnName ) , 0 , Values ))

[#3]

Thank you so much