getting highest value in a child's record

Question

Hi,&nbsp; I have a parent and a child table.On the child table I have several fields one of them being the severity level.&nbsp; What I need to do is find the child record with the highest severity for one case.&nbsp;&nbsp;Example:Case # 1234567895 child records related to caseRecord 1 - Severity level 0Record 2- Severity Level 1Record 3 - Severity Level 2Record 4 - Severity Level 2Record 5 - Severity Level 2What I need is a field that will tell me the&nbsp; highest level is severity level 2.&nbsp; I was able to do this with a checkbox formula.&nbsp; However, the three records are all checked.&nbsp; I just want one level 2 record checked.&nbsp; How can I do this?Thank you in advance​------------------------------Sandralee Oster------------------------------

markshnier__you · Answer

You have the Max Priority level up on the Parent. Look that up down to the children and call it [Max Severity level].

Then make a summary of the Maximum (or minimum) Record ID# where the Severity level = [Max Severity level] and call it [Record ID# of the first (last) child w/ Highest Severity Level].

Then look that up down to the Children.

Then your flagged child will be determined by formula where where the [Record ID#] = [Record ID# of the first (last) child w/ Highest Severity Level]

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

hannahjacobson · Answer

You can create a summary field using the 'Summary of a specific field' option
Select 'Maximum' for the field 'Security Level'

Hope that helps!

------------------------------
Hannah Jacobson
------------------------------

sandraleeoster · Answer

Hi,I already have the summary report setup to give me the Maximum severity level.&nbsp; It does return the highest number, however, it will return all records with the highest severity level for the parent record.&nbsp; I just want it to return one record with the highest level.&nbsp; I need it so that only one checkbox is selected because I also have a report that counts closed cases by severity level.&nbsp; So if one case has more than one checkbox selected for highest severity level, it will askew the results.------------------------------Sandralee Oster------------------------------

sandraleeoster · Answer

That worked perfectly!&nbsp; Thank you so much!------------------------------Sandralee Oster------------------------------

Forum Discussion

getting highest value in a child's record