Skip to Content

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

Condition - Bottom 5 values with zero suppres

Dear all,

I have built a query in which I want to apply a condition “Bottom N” to provide only the Bottom 5 entries.

Due to the fact, that the query result provides also lines with zero/no value I want to exclude them first with a second condition “not equals 0”, but the Bottom condition seems to considers the suppressed lines as well.

E.g. I have 20 records of which 5 have zero value. When I apply the “Bottom 5” condition and the “not equals 0” together, the query returns no result. Although I have suppressed the zero lines, the Bottom N condition counts these 5 records.

Is there any other way to provide the Bottom N lines in a query without considering the lines which has 0?

Any idea would be great. Thank you in advance.

Best regards

Stefanos from Munich/Germany

replied

Hi Stefanos,

what happens if you put both condition-definitions into one condition? (right now you have defined two conditions idividual, but you could merge them.

If this does not help, I would probably create a new calculated key figure, which takes over from the "PO Cov. achieved" in cases where it is not 0 and make a very big number in cases where the "PO..." equals 0.

Then let your "bottom 5" condition run against this calculated key figure.

regards

Cornelia (right now in Munich )

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question