Don't sum but count

[smilingjohn]

Hi All, 

I have a table as shown in the screenshot below .. If you look at the Defects column the total being displayed is 962 . 

and the defects are displayed as 2, 2 .where as all of them should be 1.1.1.1 they are showing double and this is the reason the total of 962 is summed up where as it should count the total ID's which 481... 

Do I need to change anything in my expression to make it appear unique rather than double?

Please help me in resolving this issue .The expression being also has count in it 

count(Distinct{<Category=P(Sub_Category),
Status={'Delivered','Dispatched','On Way'},
Severity{'1 - Critical','2 - High'}>} if(CREATE_DATE>DispatchedDate,ID))
+
count(Distinct{<Category={'null'},
Status={'Delivered','Dispatched','On Way'},
Severity{'1 - Critical','2 - High'}>} if(CREATE_DATE>DispatchedDate,ID)))

Thanks in Advance 

[smilingjohn]

Hi Expertise,

Any help on my post ?

Thanks