Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to create a pivot table with a revenue sum measure, but whenever the revenue sum is null, it shows a string eg "null" instead of just the null, smth like this
Product 1 | Product 2 | Product 3 | |
Customer X | 100 | null | 200 |
Customer Y | null | 50 | 150 |
Customer Z | 120 | 100 | null |
Is it any possible to do it through just the visualization?
I tried a bunch of different formulas but in all cases it returns null for null value cells:
if(coalesce(Sum( sales_revenue_amount_eur),0)=0,'Null','not null')
if( IsNull(Sum( sales_revenue_amount_eur)),'Null','not null')
if(Sum(sales_revenue_amount_eur)>0,1,-1)
if (Sum(sales_revenue_amount_eur)+0.1=0.1,'null',0)
if (coalesce(Sum( sales_revenue_amount_eur),0)+0.1=0.1,'null,Sum(sales_revenue_amount_eur))
if (isnull(Sum( sales_revenue_amount_eur)),1,0)
Sum( sales_revenue_amount_eur)
Thanks for help.
Maybe it doesn't work because you do not have this data in your model. This would be missing values and not null values.
In order to correct that you will need to add all the missing combinaison of values in the model
Hi -
you may want to change here for what tto dispaly if the value is null.
Hope that helps.
Maybe it doesn't work because you do not have this data in your model. This would be missing values and not null values.
In order to correct that you will need to add all the missing combinaison of values in the model
Thanks @Qrishna ! That's helpful to know!