Need to supress rows with negative values

[Former Member]

Hi all

In my Bex report (anlyzer) if the report has any negative values for a column (Quantity) field. The entire row for that negative value should be suppressed.

Can any one one please let me know how to do this?

[Former Member · Accepted solution]

Hi saathiyaa

You can create a condition on the Quantity KF in the Query Designer as Quantiy >= 0 so that it will display only the non-negative values in the report.

Hope this solves your problem.

Regards,

Ninad

[Former Member · Accepted solution]

HI ninand

Thank you for the reply, I did apply conditions, in that i have included my RKF and operator is greater than or equal to and value as 0. condition is active but still report is showing negative values for that RKF.

what I noticed is when i created a new condition, the display or change button and save button is greyed out (inactive). why is it so? any idea? because of the this condition is not working?

Thanks

[former_member182470 · Accepted solution]

Hi Saathiya,

Have you created BEx transport request before you create Condition?

Regards,

Suman

[raj_sharma]

Hi,

Create a condition on the KF as "If Quantiy <= 0 then Quantiy = 0"

and apply zero suppression on rows and columns.