Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list of people, for each person I have a % expression in this for documents correct.
I end up with the list of people with the expression result ranging from 0% to 100%
I am interested in seeing all the peoples results, but then being able to filter the ones with 100%
How can I generate a list showing the distinct % results so when selecting the 100% in the list it filters out all those who have not reached 100%
my expression for the % is
num(Count({<RFT = {'YES'}>} RFT)/Count(Document),'.%') Label - RFT
regards
May be create a list box object with this expression
Aggr( Only({1<Person = {"Count({1<RFT = {'YES'}>} RFT)/Count({1} Document) = 1"}>} Person), Person)