Replace (No Value) with an empty string

[RoccoCaliandro]

Hi everyone,

I am new on SAP Analytics Cloud and I would like to learn how to replace (No Value) in my table. My data contains empty string for EBELN but when it is empty and I add the EBELN in my table, it shows (No Value) as you can see from the picture:

I found a work around by replacing empty string with a space using the following formula:
IF(EBELN='', ' ', EBELN). 

It is working in my table but I don't want to replace data even with a space. Is there a way to do that in a more flexible way?

Thank in advance,
Rocco

[N1kh1l]

@RoccoCaliandro 

Instead of space replace it with "NA". There is no other way, Either it will appear as no value or you could replace it with a string of your choice. You can then filter those out in the dimension filter.

Nikhil