Total value doesn't match

karthikoffi27se — Sat, 16 Nov 2024 03:30:57 GMT

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

topic Total value doesn't match in QlikView

Total value doesn't match