Skip to Content

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

Feb 18, 2017 at 12:42 PM


avatar image


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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Loed Despuig 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.



10 |10000 characters needed characters left characters exceeded