I am trying to calculate burning cost, I need the split up of my expression total. my total is showing 7465 but my rows are showing
Inpatient - 1280564
Outpatient - 8281
Here is the expression i used
(sum( {<CLAIM_FLAG={'CLAIMS'},CHECK_PAIDAMT={'1'},POLICY_FLAG={'POLICY'},TREAT_FROM_NUM={'<=$(=vLRason)'}>}PAIDAMT)
+
((sum( {<CLAIM_FLAG={'CLAIMS'},CHECK_PAIDAMT={'1'},POLICY_FLAG={'POLICY'},TREAT_FROM_NUM={'<=$(=vLRason)'}>}PAIDAMT)*vIBNR)/100)
)
/
SUM({<POLICY_FLAG={'POLICY'}>}AGGR((IF(RANGEMIN((TERMINATION_DATE+1),vLRason,(TO_DATE))-(EFFECTIVE_FROM)>0,
Interval(RANGEMIN((TERMINATION_DATE+1),vLRason+1,(TO_DATE))-(EFFECTIVE_FROM))/ ((TO_DATE)-FROM_DATE)
,0)),%MEMBER_POLICY_KEY,MEMBERID))
Can you please guide me to get the expression total ie I need the split up of 7465 for both inpatient and outpatient.
Thanks in advance
Karthik
