We're building a new web site that allows customers to form and join groups.  The groups are static NetSuite groups.  We've also added the concept of badges. Customers earn badges by completing certain tasks or buying certain items.  We track that information on the customer record in a field called custentity_badges_earned (type=list).

I'm trying to create a Group saved search that lists groups and how many badges each group has earned (total of all member's badges).

This is part of my results.

Field: Name | Summary Type: Group
Field: Formula (numeric) | Summary Type: Sum | Formula: decode({customer.custentity_badges_earned},'Sponsor a Child','1')