I'm struggling to build a saved search to display available inventory for kit items. I need it sum the member item inventory at all locations and take the minimum value as that would be the most full kits we could sell given the limited quantity of a member item. How do I do a minimum of a sum?

@Greg Griffin try doing using the minimum function on a formula, and then in the formula put SUM({locationavailable})

You would want to divide location available by member quantity. Then group by kit item number and MIN of formula Columns are: Name (group) Description (group) Formula (numeric) (minimum) ROUNDDOWN({memberitem.locationavailable}/NULLIF({memberquantity}, 0), 0)