count data

[sagarrahul]

want a help in this table

clm_xgen_claim_num is also showing one time as it should show 2 and

the yellow colour data is not getting count properly its showing only one time in blue but its should show 2 .

so how to do it

HOSPITAL_NAME	HOSPITAL_CODE	CLM_XGEN_CLAIM_NUM	CLM_INTIMATION_DATE	Clm_Type	ICD_CODE_LEVEL1_org	total count of claims	ICD Code Blacklist
ADARSHA SPECIALITY HOSPITAL	HEGIC-HS-59905	RR-HS15-10333805	21-Jan-2016	REIMBURSMENT	O80.9	1	1
ADARSHA SPECIALITY HOSPITAL	HEGIC-HS-59905	RR-HS15-10333805	21-Jan-2016	REIMBURSMENT	O82.0	1	0
ADARSHA SPECIALITY HOSPITAL	Total					1	1

[varshavig12]

Simply write:

count(CLM_XGEN_CLAIM_NUM)

[MindaugasBacius]

Here you go:

Count function is used.

Take a look to the file attached.

[susovan]

Hi Sagar,

Try this,

Count(DISTINCT CLM_XGEN_CLAIM_NUM)