Forum Discussion

PiotrKryszkiewi's avatar
Qrew Trainee
3 years ago

Possibility to filter by "# of Records" in report.


I have two related table. Table A is parent for table B. In table B I have the field "Name".

Now I would like to show all the records in table B, where value in "Name" field is identical but related record "A" is different.

What I did is:
I created chart in table A with "Name" field on x axis and "# of Records" (field calculated by Quickbase, not created by me) on y axis.
Now I can see all records with bar value higher than 1 means I have duplicated "Names" in table B.

Is there any possibility to use "# of Record" in filters and filter out all records where # of Records < 2?​

Piotr Kryszkiewicz
No RepliesBe the first to reply