Chuck Tomasi
Tera Patron

Hi Stephen,



This one has me confused:



var usam = count.addAggregate('SUM','u_total_users_impacted');



I don't think you want to add another aggregate after you retrieve your count.



First question, what is the value of count at this point?



I'm going to assume that 'u_so_incident_impacts' is your parent table. If that's the case, you want to count the records on the child table that have the same parent sys_id, not the number.