@nzaleski If you want unique values only counted have you tried returning internal ID instead of 1 and then doing a count? If you still need to show 1 or zero on the detail do a separate column for the internal id to count on the summary.