https://community.sap.com/t5/crm-and-cx-q-a/c4c-report-how-to-get-blank-instead-of-quot-not-assigned-quot-for/qaa-p/12082058#M410922 <P>Hi Christopher,</P><P> This is the system behaiviour . in a report or data source if there is no value maintain in master data it show as # or not assigned . you can not change it with other value</P><P>Thank you </P><P>Jalil </P> Tue, 17 Dec 2019 12:34:19 GMT former_member412795 2019-12-17T12:34:19Z https://community.sap.com/t5/crm-and-cx-q-a/c4c-report-how-to-get-blank-instead-of-quot-not-assigned-quot-for/qaq-p/12082054 <P>Hi experts, </P> <P>I would like to create a report with characteristics of type dropdown. If no value was selected for these fields, the report shows the string "Not assigned". I have searched all over but have not found any way to change this behaviour and get the report to output a blank.</P> <P>Does anyone know if there is a way to configure a report to output blanks instead of "Not assigned" (or # for that matter)?</P> <P>Thanks!</P> Thu, 17 Oct 2019 06:31:33 GMT https://community.sap.com/t5/crm-and-cx-q-a/c4c-report-how-to-get-blank-instead-of-quot-not-assigned-quot-for/qaq-p/12082054 chrigu1 2019-10-17T06:31:33Z https://community.sap.com/t5/crm-and-cx-q-a/c4c-report-how-to-get-blank-instead-of-quot-not-assigned-quot-for/qaa-p/12082055#M410919 <P>Hi Christopher,<BR />technically there is a difference between blank and "# - not assigned". So I do not think you should replace it with blank.</P><P>Best regards</P><P>Marlene</P> Wed, 23 Oct 2019 16:16:56 GMT https://community.sap.com/t5/crm-and-cx-q-a/c4c-report-how-to-get-blank-instead-of-quot-not-assigned-quot-for/qaa-p/12082055#M410919 Marlene_k 2019-10-23T16:16:56Z https://community.sap.com/t5/crm-and-cx-q-a/c4c-report-how-to-get-blank-instead-of-quot-not-assigned-quot-for/qaa-p/12082056#M410920 <P>Hello Marlene,</P><P>I have the same question Christopher has raised: how to configure the report to output blanks instead of # (or not assigned).</P><P><STRONG>How to do that?</STRONG></P><P>Thank you!</P> Mon, 18 Nov 2019 13:30:35 GMT https://community.sap.com/t5/crm-and-cx-q-a/c4c-report-how-to-get-blank-instead-of-quot-not-assigned-quot-for/qaa-p/12082056#M410920 catalin_duta 2019-11-18T13:30:35Z https://community.sap.com/t5/crm-and-cx-q-a/c4c-report-how-to-get-blank-instead-of-quot-not-assigned-quot-for/qaa-p/12082057#M410921 <P>Hi Catalin, </P><P>I have not found an answer to this question other than Marlene's suggestion not to replace it. The fact is, that business users prefer to see an empty cell. Also visually it is much more clear to identify an empty cell (e.g. in Excel) instead of "Not Assigned". </P><P>Regards Christopher.</P> Tue, 19 Nov 2019 16:32:37 GMT https://community.sap.com/t5/crm-and-cx-q-a/c4c-report-how-to-get-blank-instead-of-quot-not-assigned-quot-for/qaa-p/12082057#M410921 chrigu1 2019-11-19T16:32:37Z https://community.sap.com/t5/crm-and-cx-q-a/c4c-report-how-to-get-blank-instead-of-quot-not-assigned-quot-for/qaa-p/12082058#M410922 <P>Hi Christopher,</P><P> This is the system behaiviour . in a report or data source if there is no value maintain in master data it show as # or not assigned . you can not change it with other value</P><P>Thank you </P><P>Jalil </P> Tue, 17 Dec 2019 12:34:19 GMT https://community.sap.com/t5/crm-and-cx-q-a/c4c-report-how-to-get-blank-instead-of-quot-not-assigned-quot-for/qaa-p/12082058#M410922 former_member412795 2019-12-17T12:34:19Z https://community.sap.com/t5/crm-and-cx-q-a/c4c-report-how-to-get-blank-instead-of-quot-not-assigned-quot-for/qaa-p/12082059#M410923 <P>I have now added an improvement request for this topic: <A href="https://influence.sap.com/sap/ino/#/idea/241166">https://influence.sap.com/sap/ino/#/idea/241166</A></P><P>Please feel free to leave your vote!</P><P>Regards Christopher. </P> Wed, 18 Dec 2019 16:09:33 GMT https://community.sap.com/t5/crm-and-cx-q-a/c4c-report-how-to-get-blank-instead-of-quot-not-assigned-quot-for/qaa-p/12082059#M410923 chrigu1 2019-12-18T16:09:33Z