Skip to Content

Zero in place of blank value in Bex query?

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 11, 2013 at 02:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2013 at 04:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10, 2013 at 06:40 PM

    Hi

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

    Regards,

    RC

    Add comment
    10|10000 characters needed characters exceeded