Count is return unique count problem

[wuming79]

Hi,

I have a table as below:

IP	start sequence
1.1.1.1	-
2.2.2.2	1
1.1.1.1	1
3.3.3.3	2
1.1.1.1	2
4.4.4.4	3

I just wanted to count the number of IP that appears on the table using SUM(IP) but the table I get is unique count instead.

IP	SUM(IP)
1.1.1.1	1
2.2.2.2	1
3.3.3.3	1
4.4.4.4	1

I'm not sure why am I getting this issue... when I uncheck show start sequence NULL, I can see there are 2 x 1.1.1.1.

[tomasz_tru]

use: COUNT(IP)

[wuming79]

Hi,

same issue. it will count as unique. I'm not sure if this is affected by other tables that has IP column? I actually has 4 tables that are linked by "IP" and they all have a key icon beside them when I look at the Data Model Viewer.

[wuming79 · Accepted solution]

Hi, I found the problem. I had to rename one of the fields because the field I am counting is a key and count the new fieldname.