cancel
Showing results for 
Search instead for 
Did you mean: 

showing a space instead of a "#"

Former Member
0 Kudos
56

Is it possible to show a blank instead of a "#" (not assigned). That is, whenever a value is #, I want to show it as a blank instead of #. Is this possible?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Please go to the properties/settings of the query. There you can replace 0 with #, or # with 0, or anyother figure, but I don't think blank is possible.

Thanks,

Saket

Former Member
0 Kudos

You can use a Macro to replace # with a blank.

Hope this helps.

Bhargava

Former Member
0 Kudos

Hi Sista,

Can you explain in detail how to use the macro?

Former Member
0 Kudos

But then I would have to use Analyzer. I show all my reports in WAD.

Former Member
0 Kudos

I dont think thats possible to replace unassigned to someother value dynamically, work book would be a workaround.