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.