Select field

[Anonymous]

Hi folks,

for my customer I calculate the changes of requests from one month to another (using variables). I get a set of requests.

=

Count( DISTINCT {$ < Berichtsdatum=,AuswahlJahr=, AuswahlMonat=,KBTyp={'Bestand'},VertragsNummer= P({<Berichtsdatum={'$(=vDatum2)'}>} VertragsNummer)-
P({<Berichtsdatum=,AuswahlJahr=, AuswahlMonat=,KBTyp={'Bestand'},Berichtsdatum={'$(=vDatum1)'}>} VertragsNummer)>} VertragsNummer)

Now I would like an easy solution to select all relevant requests. Showing the respective field will show more than the requests with above formula.

I can use the same formula in the Listbox (expression) and I do get

Request

1111111     1

2222222     1

3333333     1

...

...

abcdefg     0

defghijk     0

The new requests are shown with "1" in second column. Is there an easy way to select all requests with "1" in second column (without manually select them)?
WHat I weant to achieve is to select the requests and  goto other charts/table to display further informationabout these requests (but without using the above forumla).

Any ideas?

[marcus_sommer · Accepted solution]

Maybe you could use a second listbox with an expression: if(YourExpression) >= 1, 1, 0) and used for both listboxes a container or a dimension-group - to keep the gui clean and show that both are related.

- Marcus