Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

Holding % of claims

Hi Friends

Please help me to see where I have gone wrong in deciding percentage held by each products in total claims. The percentage obtained seems to be wrong.

((SUM({<ACCOUNT_CODE={'73110','73210','73260','73310','73320','73360','73510','73740','73760','73160','73460','73560','73270'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}DR-CR))+(SUM({<ACCOUNT_CODE={'74110','74160','74210','74260','74270','74310','74360','74460','74510','74560','74740','74760','74320'}>}DR-CR))+(SUM({<ACCOUNT_CODE={'74115','74165','74215','74265','74275','74315','74365','74465','74515','74565','74745','74766','74325'}>}DR-CR))+(SUM({<ACCOUNT_CODE={'74116','74216','74266','74316','74326','74366','74516','74236','74765','74166','74466','74566','74276','74765'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}DR-CR))+(SUM({<ACCOUNT_CODE={'77233','77234','77232','77246','77247','77245','77237','77241'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}DR-CR))-(SUM({<ACCOUNT_CODE={'75115','75225','75265','75315','75325','75365','75442','75691','75165','75570','75545'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}CR-DR))-(SUM({<ACCOUNT_CODE={'75120','75230','75270','75320','75370','75443','75692','75170','75470','75565','75540','75321'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}CR-DR))-SUM({<ACCOUNT_CODE={'75110','75310','75210','75220'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}CR-DR)-(SUM({<ACCOUNT_CODE={'75750','75730','75710','75720','75740','75800','75760','75860'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}CR-DR)))/((SUM(TOTAL{<ACCOUNT_CODE={'73110','73210','73260','73310','73320','73360','73510','73740','73760','73160','73460','73560','73270'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}DR-CR))+(SUM({<ACCOUNT_CODE={'74110','74160','74210','74260','74270','74310','74360','74460','74510','74560','74740','74760','74320'}>}DR-CR))+(SUM({<ACCOUNT_CODE={'74115','74165','74215','74265','74275','74315','74365','74465','74515','74565','74745','74766','74325'}>}DR-CR))+(SUM({<ACCOUNT_CODE={'74116','74216','74266','74316','74326','74366','74516','74236','74765','74166','74466','74566','74276','74765'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}DR-CR))+(SUM({<ACCOUNT_CODE={'77233','77234','77232','77246','77247','77245','77237','77241'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}DR-CR))-(SUM({<ACCOUNT_CODE={'75115','75225','75265','75315','75325','75365','75442','75691','75165','75570','75545'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}CR-DR))-(SUM({<ACCOUNT_CODE={'75120','75230','75270','75320','75370','75443','75692','75170','75470','75565','75540','75321'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}CR-DR))-SUM({<ACCOUNT_CODE={'75110','75310','75210','75220'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}CR-DR)-(SUM({<ACCOUNT_CODE={'75750','75730','75710','75720','75740','75800','75760','75860'},PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','HH','EN','HH','SS','MR','SI'}>}CR-DR)))

5 Replies
shiveshsingh
Master
Master

Hi

what is the error? Your attached file doesn't have any data to check.

nevilledhamsiri
Specialist
Specialist
Author

please check the attachment whether it contain data.As per Claim data ratio it seems to be incorrect which should be due to some  errors in the formula

BR_CODE PRODUCT_CODE SUM({<PRODUCT_CODE={'FR','TC','MS','MC','M4','M3','TT','PP','EN','HH','SS','MR','SI'},REF={'GROSS_PREMIUM'}>}C_BALANCE)SUM({<PRODUCT_CODE={'MC','TC','HH','PP','M4','MS','TT','EN','M3','EN','SS','MR','SI'},ACCOUNT_CODE={'61210','61260','61310','61320','61360','61510','61740','61760','61160','61460','61560','61270'}>}C_BALANCE) / SUM(TOTAL {<PRODUCT_CODE={'MC','TC','HH','PP','M4','MS','TT','EN','M3','EN','SS','MR','SI'},ACCOUNT_CODE={'61210','61260','61310','61320','61360','61510','61740','61760','61160','61460','61560','61270'}>}C_BALANCE)  CLAIMSHOLDING CLAIMS AS A %
EHEN-3962460%182140%
FR-15017970%1066710%
HH-758450%7590%
M3-18100872%645050%
M4-181080%270540%
MC-2231988726%1178003728%
MS-6627971%249370%
PP-3876690%295020%
TC-15536742%-53291-0%
TT-37000%1170%
Total -28729810 31% 11998505 29%
RAEN-24221943%11651613%
FR-73725900%15091284%
HH-960350%13870%
M3-36989744%1342700%
M4-1843550%6347152%
MC-4892658156%2062011555%
MR00%2790%
MS-18514342%6046421%
PP-10283101%3040781%
SI-8400461%9460%
SS-177000%1207530%
TC-11688611%4622731%
TT-507500%15990%
Total -67657829 69% 25559347 68%
Total -96387638 100% 37557852 100%
nevilledhamsiri
Specialist
Specialist
Author

Hi Shivesh,

Could you please see why the correct % is nor arrived at.

nevilledhamsiri
Specialist
Specialist
Author

Any idea on the requested issue please. If I am given kind of a hint, may be I will be able to proceed

nevilledhamsiri
Specialist
Specialist
Author

Dear vishwarath

Could you please see to this

Neville