# NOT ASSIGNED in Report

[Former Member]

Hi Experts,

I've got a report with many master data of a customer. But not always all data are maintenanced. The result is, that instead of blank there's "#" or 'Not assigned" value. How can I change this to blank?

Thanks a lot for your help

[former_member205352 · Accepted solution]

In BI

For characteristics

key : # and text : "Not Assigned" means No data.

For key figures :

Its blank or 0 for no data .

Hope this helps.

[Former Member · Accepted solution]

Hi,

i know, but I don't want to show them. If "#" or "Not assigned", I want to show blank.

Is there any possibility?

Regards

[Former Member · Accepted solution]

Hi,

Goto that keyfigure -->right click >restrict>select # from left panel >drag it in to right side panel>again right click on # >exclude from selection.>execute it.

Regards

Pcrao.

[Former Member · Accepted solution]

Hi Pcrao,

thanks for xour help. But I've got a problem being much more tricky...

E.g. I'vo got a datasource showing only attributes of customer, like name, telnumber, personal address, etc. The problem is, that not all fields of any customer are filled.

The result is e.g.

1) Mr. Max Mustermann, Musterstreet 1, 12345 Musterstadt, #

2) Ms. # Musterfrau, #, #,#, 01234/78945,

3) Mr. Juergen Klinsmann, Bayernallee 1, 2222 Muenchen, 01234/78542

You understand my problem?

If I do it like you advise, there will only Mr. Klinsmann showed, but not the others. My wish would be like this:

1) Mr. Max Mustermann, Musterstreet 1, 12345 Musterstadt

2) Ms. Musterfrau, 01234/78945

3) Mr. Juergen Klinsmann, Bayernallee 1, 2222 Muenchen, 01234/78542

Is there a possibility?

Regards Sebastian