Skip to Content

How to Hide Zero from the report and combine in one row using Bex Query


I have create BEx query Based on Mutiprovider.the user want to hide the zero value from the report and show in one row.but i am using two different infobject for displaying the value.

one infoobject is showing Zero value and one infoobject is showing some value but contains in different row. Here I am Attaching one file where Dealer 615 has showing two value(17 and 0) i want display only 17.

Pls support.

ad-error.png (46.2 kB)
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Mar 07, 2017 at 09:13 AM


    You can activate the SUPPRESSION OF ZERO in ROWS in your query.

    Aside from that, you should have an IF statement in your FORMULA33.

    For example, your FORMULA33 contains this FORMULA33 = 1.

    Then you should revise it with this.

    FORMULA33 = (QTY == 0) * 0 + 1

    QTY is the KF on the left of FORMULA33.

    1 is the formula inside the current FORMULA33.

    Just post here your questions.



    Add comment
    10|10000 characters needed characters exceeded