Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Exclude values on report when certain characteristic combinations occur

Hello,

I have a query in which I would like to exlude certain characteristic combinations from being in the report body.

For example, when I run my query I would like to exclude values from my report when:

The PLANT is a certain value AND when the SALES GROUP is a certain value. (They both need to meet the criteria)

If the plant is 0007 and Sales Group is Unassigned then don't show the corresponding values on the report.

If the plant is 0007 and Sales Group is 030 then the values are displayed.

So that is the distinction.

I am not sure how to achieve this. Any assistance would be great!

Thanks,

Nick

Message was edited by:

Nick Bertz

Former Member
replied

Hi Nick,

I think I the issue...try using the NOT function (expression). That should make 0 as 1 and 1 as 0.

Hope this helps...

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question