You are doing a record by record check and breaking records into 2 groups - HVD and No HVD
then you are coming back at the at the Corp ID level and asking which corp ID is in each group but there are some that have records in each group
so what to do
you can clay with an LOD (or not really needed) and take the Min(HVD Incicents) (H is < N ) and just place the Corp ID in the viz
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.