Skip to Content
0
Former Member
Jan 08, 2009 at 11:09 AM

Modify or determine the sequence of conditions

50 Views

Hi Forum,

There's a problem I'd like to solve.

I hope anyone can help me?

There's a query with 2 characteristics in rows.

For these characteristics are 3 formulas in columns using some selections.

On this setting we need 3 different conditions.

Step 1:

The first conditions should restrict the first characterics to the top x regarding formula 1.

Step 2:

The second condition should delete these characteristic of characteristic 2 less than a given value in formula 2.

Step 3:

The third condition sould restrict the remaining number of the characteristic 2 to the top x of fomula 3.

The sequence is fundamental.

Currently the top x of Step 3 seems to be calculated, but on this top x, the values of Step 2 where deleted. So, just the top x - y remains.

Has anyone an idea?

Thanks in advance for any idea.

Tobias