Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hiiiii
want a help in this .
this is my table .
CLM_XGEN_CLAIM_NUM Black List Code
RC-HS15-10334760 H26.9
RC-HS15-10335711 H26.9
RC-HS15-10341139 H26.9
RC-HS15-10343361 H26.9
RC-HS15-10336529 H25.9
RC-HS15-10336520 H26.9
RC-HS15-10337526 H26.9
-
RR-HS15-10336940 R57.2
RR-HS15-10341978 -
RC-HS15-10333637 N18.4
RR-HS15-10341246 N18.9
RC-HS15-10331178 R50.9
RR-HS15-10336696 N85.2
RC-HS15-10343151 S52.9
RC-HS15-10333670 G40.6
RR-HS15-10341978 G40.6
RR-HS15-10339968 S52.9
RC-HS15-10330851 A01.0
RC-HS15-10344631 S83.5
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1) in this i want total count of CLM_XGEN_CLAIM_NUM and total count individual Black List Code
2) after geting "point 1" it should divide "CLM_XGEN_CLAIM_NUM / total count individual Black List Code"
3) after diving then if the values goes >=0.7 then is should show as "OUTLIER" othervise "NOT OUTLIER".
"help me in Expression "
hope u got what i want .
so please help me in this as soon as possible .
for example :
CLM_XGEN_CLAIM_NUM Black List Code value status
total 7 7 1 OUTLIER
Check this,
