Does anyone have a solution for this general problem. So you have a saved search with a numeric formula. Something like CASE WHEN {available} > 0 THEN 1 ELSE 0. It works perfect on search that does not have summary. But then when you try to GROUP by another column and SUM up the formula it counts it 2 or 3 times. My guess is because it is not MAIN LINE = TRUE therefor it is counting for the JOINED tables 2 or 3 times.