Announcements
cancel
Showing results for
Did you mean:
Creator

## dividing single value with total

hii good morning need a help

this is my table

 HOSPITAL_NAME HOSPITAL_CODE CLM_XGEN_CLAIM_NUM CLM_INTIMATION_DATE Clm_Type ICD_CODE_LEVEL1_org total count of claims ICD Code Blacklist Value ADITYA HOSPITALS HEGIC-HS-23852 RR-HS15-10335372 01-Feb-2016 REIMBURSMENT R50.9 1 1 0.1000 ADITYA HOSPITALS HEGIC-HS-23852 RR-HS15-10335372 01-Feb-2016 REIMBURSMENT - 1 0 0.1000 ADITYA HOSPITALS HEGIC-HS-23852 RR-HS15-10336083 05-Feb-2016 REIMBURSMENT S42.0 1 1 0.1000 ADITYA HOSPITALS HEGIC-HS-23852 RR-HS15-10336083 05-Feb-2016 REIMBURSMENT - 1 0 0.1000 ADITYA HOSPITALS HEGIC-HS-23852 RR-HS15-10338653 22-Feb-2016 REIMBURSMENT N39.0 1 1 0.1000 ADITYA HOSPITALS HEGIC-HS-23852 RR-HS15-10338653 22-Feb-2016 REIMBURSMENT - 1 0 0.1000 ADITYA HOSPITALS Total 3 3 0.3000

i want to divide ( individual ICD_CODE_LEVEL1_org /total count of claims )

eg :

R50.9/3

means 1/3=0.3333

i am getting a problem its dividing whole column as u can see i have mark it in yellow colour

so can any one help me in this !!!!!!

17 Replies
Anonymous
Not applicable

Hi Sagar:

Count(ICD_CODE_LEVEL1_org)/COUNT(TOTAL CLM_XGEN_CLAIM_NUM)

You have 1 claim by ICD_CODE_LEVEL, and 3 claims in total.

Change on chart properties, the number format of your expression.

Regards.

Creator
Author

thank you manuel capella

Change on chart properties, the number format of your expression.

can u guide me in this in detail

Anonymous
Not applicable

Hi Sagar,

See that picture. On chart properties, search the number tab. Select your Expression and then, select Fixed to, and set all decimals do you wanna see.

Regards!!

Partner - Creator

Hi Sagar,

if you want to show result in table ... then you can Write

Count(ICD_CODE_LEVEL1_org)/COUNT(TOTAL CLM_XGEN_CLAIM_NUM)

and if you want to divide by value then

Sum(ICD_CODE_LEVEL1_org)/COUNT(TOTAL CLM_XGEN_CLAIM_NUM)

if you share your sample data so able to show you

Creator
Author

need one help

this is my table

in this i have marked column ICD_CODE_LEVEL1_org in that there are certain data which is repeated so i want

there sum divided by TOTAL CLM_XGEN_CLAIM_NUM

eg :

R50.9 is respeated 3 times

so i want 3/8=0.375

can u help me in this also

Anonymous
Not applicable

Hi Sagar:

Count(DISTINCT ICD_CODE_LEVEL1_org)/COUNT(TOTAL DISTINCT CLM_XGEN_CLAIM_NUM)

Regards!!

Creator
Author

see i am not getting what i want

 HOSPITAL_NAME HOSPITAL_CODE CLM_XGEN_CLAIM_NUM CLM_INTIMATION_DATE Clm_Type ICD_CODE_LEVEL1_org total count of claims ICD Code Blacklist ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS15-10330924 02-Jan-2016 REIMBURSMENT R39.8 1 1 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS15-10330924 02-Jan-2016 REIMBURSMENT T80.9 1 1 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS15-10330924 02-Jan-2016 REIMBURSMENT - 1 0 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS15-10337460 14-Feb-2016 REIMBURSMENT J20.9 1 1 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS15-10337460 14-Feb-2016 REIMBURSMENT - 1 0 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS16-10349433 30-Apr-2016 REIMBURSMENT I25.4 1 1 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS16-10349433 30-Apr-2016 REIMBURSMENT - 1 0 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS16-10349435 30-Apr-2016 REIMBURSMENT I25.4 1 1 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS16-10349435 30-Apr-2016 REIMBURSMENT - 1 0 ROCKLAND HOSPITAL LTD Total 4 5
Creator
Author

it is not getting full table will divide it

 HOSPITAL_NAME HOSPITAL_CODE CLM_XGEN_CLAIM_NUM CLM_INTIMATION_DATE ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS15-10330924 02-Jan-2016 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS15-10330924 02-Jan-2016 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS15-10330924 02-Jan-2016 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS15-10337460 14-Feb-2016 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS15-10337460 14-Feb-2016 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS16-10349433 30-Apr-2016 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS16-10349433 30-Apr-2016 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS16-10349435 30-Apr-2016 ROCKLAND HOSPITAL LTD HEGIC-HS-14794 RR-HS16-10349435 30-Apr-2016 ROCKLAND HOSPITAL LTD Total

 Clm_Type ICD_CODE_LEVEL1_org total count of claims ICD Code Blacklist REIMBURSMENT R39.8 1 1 REIMBURSMENT T80.9 1 1 REIMBURSMENT - 1 0 REIMBURSMENT J20.9 1 1 REIMBURSMENT - 1 0 REIMBURSMENT I25.4 1 1 REIMBURSMENT - 1 0 REIMBURSMENT I25.4 1 1 REIMBURSMENT - 1 0 4 5

now it is clear to u get it sorted

Anonymous
Not applicable

Count of ICD_CODE -> =Count(DISTINCT ICD_CODE_LEVEL1_org)

Count of CLAIM_NUM -> Count(DISTINCT CLM_XGEN_CLAIM_NUM)

Division -> Count(DISTINCT ICD_CODE_LEVEL1_org)/Count(DISTINCT CLM_XGEN_CLAIM_NUM)

Regards!

Community Browser