Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have a data policyno, claimno, prem, claimamt.
I want create a chart with policyno wise claimamt. claimamt should be caluculated by claimno and then sum to policyno wise base on the logic given.
Post:
****
If ClaimAmt of each claim is greater than 100000 then 100000 else ClaimAmt.
Pre:
***
If ClaimsAmt of each claim is greater that 100000 then ClaimAmt - 100000 else zero.
Please let me know how to calculate Post & Pre column.
The output should be like Output table. Only policy dimension to be used.
Please see the qvw file attached for your reference.
Thanks,
Jagan. V
Create a straight table chart with dimension policy nr. then 3 expression:
=sum(ClaimAmt)
=sum(if(ClaimAmt>100000,100000,ClaimAmt))
=sum(if(ClaimAmt>100000,ClaimAmt-100000,0))
Is this the correct sample file? Please recheck, I don't see your claim data.
Sorry the attachment was wrong, Please check now.
Create a straight table chart with dimension policy nr. then 3 expression:
=sum(ClaimAmt)
=sum(if(ClaimAmt>100000,100000,ClaimAmt))
=sum(if(ClaimAmt>100000,ClaimAmt-100000,0))