getting highest value in a child's record

Question

Hi,  I have a parent and a child table.On the child table I have several fields one of them being the severity level.  What I need to do is find the child record with the highest severity for one case.  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  highest level is severity level 2.  I was able to do this with a checkbox formula.  However, the three records are all checked.  I just want one level 2 record checked.  How can I do this?Thank you in advance​------------------------------Sandralee Oster------------------------------

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
------------------------------

Sign up

Login to the community