Forum Discussion

Qrew Cadet

5 years ago

Summarize distinct child records by a text field

I have a parent table (Botruns) that has many children (Line items). The line items could either be processed or not processed and the data for that resides in the line item record in the child table....

Relationships

DeepaPrashant1

Qrew Cadet

Yes, but the reasons are recorded on the child record in text format in a field 'Reason not processed'. Each child record has a field called SvcOrderLine# which if unique will determine which child records to count. But in the child table itself, the line record is not marked as unique. While I can do a distinct count of unique child records, how do I do a distinct count of each 'Reason not processed'?

------------------------------
Deepa Deepa
------------------------------

MarkShnier__You

Qrew Legend

5 years ago

Are you looking to count the unique combinations of the SvcOrderLine# and the Reason not processed?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------