get a distinct list from expression results

spikenaylor1 — Sat, 16 Nov 2024 21:04:45 GMT

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

Re: get a distinct list from expression results

sunny_talwar — Wed, 10 Apr 2019 11:43:16 GMT

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)