Forum Discussion
MarkShnier__You
5 years agoQrew Legend
Are you simply trying to count the number of unique reasons for not being processed. Is that the goal?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- DeepaPrashant15 years agoQrew CadetYes, 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__You5 years agoQrew LegendAre 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
------------------------------
- DeepaPrashant15 years agoQrew CadetTo clarify by counting the reasons, I assume i will know by reason description the count.
1. PWO only - count
2. Locked by user - count etc.
------------------------------
Deepa Deepa
------------------------------- MarkShnier__You5 years agoQrew LegendI suggest that you give an example of the child data and the result that you expect.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- DeepaPrashant15 years agoQrew CadetMark,
I just needed you to push me and get me to think. I figured it out :-)
Thanks!!!
------------------------------
Deepa Deepa
------------------------------