Show NULL for sum of null values

[#1]

Hello,

I have a straight table with different values, some of them are null values.

One of columns shows a sum of the values. Somehow I cannot  show NULL (or a Dash '-') for the sum column, even the sum of NULL-Values obviously is NULL and not zero '0'.

Is there a way to show NULL in this case without  any if-statement?

My real data is to large to post it here, but I have created a similar example.

In the example I need to show NULL or a dash for the column "sum(deleted)".

Any ideas.

Thanks

[rupamjyotidas]

Use this from Presentation

[settu_periasamy]

Try this..

Sum(Deleted) * (Avg(Deleted)/Avg(Deleted))

Link :  Handling Null Values in Expression (Sum)

[#4]

Thank you guys for the recomendations.

The idea in presentation is definitely not working. The second one with the expression is

Is there a way to do this without adding an expression in QliKView?.