Skip to Content
avatar image
Former Member

How to replace null values with zero or one in sap bex

How to replace null values with zero or one in sap bex?

Thanks,

Sridhar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 06, 2012 at 06:00 AM

    We can replace the values with other values by using formula variable with processing type - customer exit.

    Go to conditions icon on top of BEx analyser, select the object and equal to value click on variable entry select customer exit.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 06, 2012 at 12:09 PM

    Hi,

    In Query property u can suppress all row and columns values which is 0.

    Go to query property > row or column > do all required setting as per row or column or with row and colums.

    Add comment
    10|10000 characters needed characters exceeded