Zero in place of blank value in Bex query?

[Former Member]

Hi,

in my report for a particular key figure i am getting a blank value. client is asking me to show a zero instead of blank value for a particular cell?

[RamanKorrapati · Accepted solution]

Hi Sudha,

Pls go thru it

http://scn.sap.com/thread/1930152

Below thread is reverse, but steps are same.

http://scn.sap.com/thread/3291102

Regards

[anshu_lilhori]

Hi,

Make a new formula and put your KF inside it then + 0....This will display blank values as zeros.

Also to check go to query properties--value display tab---display zero as space should not be selected.

If this is selected then it will display as blank only.

Hope this helps.

Regards,

AL

[ravi_chandra3]

Hi

Go to the query properties  and in the display tab , make the setting.

Regards,

RC