Change empty fields '-' to '0'

[MaartenDB]

Hi

I am currently building in Datasphere but I ran into a small problem. The fields that contain no values (displayed as '-' in datasphere, get filtered out later on in my view. But fields that have a '0' as value, do not get filtered out. So an "easy" solution to this seems to convert all the empty fields into '0', but I do not manage to find the expression for this. Anyone who can help me? Thanks in advance

[Chris_Tam · Accepted solution]

You can create a formula that checks your dimension. Something like:

case when "MY_FIELD" is null then 0 else "MY_FIELD" end

And then use that in your views instead.

[albertosimeoni]

'-' at database level is NULL.

But if you look at it in dataflows it really is '-' if you need to filter it out.

and if you have a date type field you need to use '-' to filter it out anyway.

(i've never unverstood why)