Display counts not sum

[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

[sidhiq91]

@smilingjohn is it possible to provide some sample data for us to work upon?

[smilingjohn]

Thanks for the reply Sidhiq 

Sorry but  cannot post the data ... I have the expression which I have posted. 

Thanks

[smilingjohn]

Hi All,

Tried all the options that I know but no luck ....