Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Avoiding # in BI reports

Hi All,

We all aware that in BI reports wherever if the characteristic value is empty (Null) we get it as '#' in the query o/p.

I have a requirment for example, if the Gender is not maintained then for a customer/employee and if i pull out the report based on Gender wise i will have 'M', 'F' and '#' in the output. but instead of '#', i need to display some text like 'Others'.

How can i acheive this.

Thanks in advance

Prem

Former Member
Former Member replied

Hi Prem

I understand your problem. See the following blog to change the value in WAD with javascript:

/people/andrey.uryukin/blog/2010/08/29/formatting-bex-queries-output-with-wad-script-webitem

Louis

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question