zehang

Count of function in Summary

Discussion created by zehang on Oct 12, 2014
Latest reply on Oct 13, 2014 by erolst

Hi! I am wondering whether there is a way to count in a summary field for only how many unduplicated record are there. for example, there are 3,2,2 customer(s) from company A,B,C respectively, how to count the number of the companies of all the customers, which is supposed to be 3? if simply set the summary field to be the COUNT OF field COMPANY, it apears it will be calculated to be 7=3+2+2.

 

Thanks so much in advance.

Outcomes