Forum Discussion

PiotrKryszkiewi's avatar
PiotrKryszkiewi
Qrew Trainee
3 years ago

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

Hi,

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