Is it possible to surpress null value in a textbox?

[#1]

Hi there, i hope someone can help me with my little problem.

Is is possible, like in the charts, to surpress null value for a dimension in a textbox?

I would like to surpress/remove the pink values in the total sum of the pie chart in the text field.

Thanks
Teis T.W.

[CELAMBARASAN · Accepted solution]

Try something like

Sum({<Hovedbranche={"*"}>*$} Oms)

[#3]

Many thanks Celambarasan Adhimulan, it Works!

For a side quastion - How does the *$ at the end, work in the set analysis ?

[CELAMBARASAN]

It results you the Intersection between the selection($) and the set analysis conditions.

Just it will make the chart to work if any selection made on that field also. If you didn't use that then selection in the field Hovedbranche will be ignored.