Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
Finally I solved with this Set Expression:
=Count({1-1<Corrected_ID={"**"}>} DISTINCT ID)
maybe
GetExcludedCount(Corrected_ID)
can help you
You can use this functions:
- GetCurrentSelections (...)
- GetFieldSelections (...)
- GetSelectedCount (...)
- GetPossibleCount (...)
- GetExcludedCount (...)
nad more ....
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.
Finally I solved with this Set Expression:
=Count({1-1<Corrected_ID={"**"}>} DISTINCT ID)
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