If to count excluded values (Set Analysis)

[cristian_av]

Hi

I have two field:

ID

Corrected_ID

What I want is:

a) Select All Values from ID

b) Select Excluded Values from Corrected_ID

c) Count all this values (And use this number in a If)

I'm doing that actually using actions, but I need to use that count inside a if, and with actions I think it is not possible.

How can I get that count with some Set Analysis Expression??

[maxgro]

maybe

GetExcludedCount(Corrected_ID)

can help you

[ecolomer]

You can use this functions:

- GetCurrentSelections (...)

- GetFieldSelections (...)

- GetSelectedCount (...)

- GetPossibleCount (...)

- GetExcludedCount (...)

nad more ....

[cristian_av]

But all the functions you both give me, don't accept any kind of SetAnalysis, So for using that functions I will have to select manually the ID Values.

Is there any other way so I can force an expression to consider the count of excluded values of Corrected_ID, But without having to do a selection in the ID field?

I just need the count of excluded values, and I don't want to change the current selection for the user.

[cristian_av · Accepted solution]

Finally I solved with this Set Expression:

=Count({1-1<Corrected_ID={"**"}>} DISTINCT ID)

[mseeck75]

Hi Cristian,

without any knowledge about  the structure of your fields (e.g. both fields in one table or different tables, how to linked etc.) I would suggest to use these expression

                                        =count( {1-$} Corrected_ID)

You can further refine this expression to your requirements.

Hope that helps.

BR

Matthias