Condition - Bottom 5 values with zero suppres
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.
Stefanos from Munich/Germany
Cornelia Lezoch replied
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.
Cornelia (right now in Munich )