Skip to Content
Former Member
Apr 19, 2007 at 07:47 PM

Filter the records when KF condition exists


Dear all,

I would like to eliminate all the records when a condition exists on my KeyFigures.

Say, the records should be filtered from the query when KF1 is zero and when KF2 is <0.

I created a formula KF which gives value 1 when above mentioned condition exists and 0 if not. But I would like to know how to eliminate all the records when this formula KF value is one.

Note: all my KFs are in a structure.

Please send in your feedback.