Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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 ))
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 ))
Thank you so much