cancel
Showing results for 
Search instead for 
Did you mean: 

Query

Former Member
0 Kudos

Hi Friends

How can I display # values as '0' on query display.

Regards,

Chama.

Accepted Solutions (1)

Accepted Solutions (1)

former_member205352
Active Contributor
0 Kudos

For Characteristics I dont think so you can replace # with 0.

As in the master data maintenance 0 will be taken as blank,which inturn is #.

Hope this helps.

Former Member
0 Kudos

Hi

Thanks for reply.

How can I replace blanks to 0 on Bex analyser.

Regards,

Chama.

rajkumar_kandula
Active Contributor
Former Member
0 Kudos

Hi,

If you are using 3.x Workbook. then you can add the following code in the Module and it will work.


Sub SAPBEXonRefresh(queryID As String, resultArea As Range)
         resultArea.Replace "#","0"
End Sub

This should do it.

Hope this helps.

Datta.

Answers (0)