cancel
Showing results for 
Search instead for 
Did you mean: 

Change empty fields '-' to '0'

MaartenDB
Discoverer
0 Kudos
239

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

View Entire Topic
Chris_Tam
Explorer
0 Kudos

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.