FIELD SUM

sagaraperera — Wed, 24 Aug 2022 10:59:11 GMT

DEAR ALL

PLEASE FIND THE BELOW AND GIVE THE SOLUTION.

1)I WANT GET A TOTAL IN CEEDED_PREMIUM

2)I WANT GET A TOTAL IN NET_CLAIMS

3)I WANT GET A TOTAL IN NET_PROFIT

DESCRIPTION	ACTUAL
GROSS_PREMIUM	14,915,582
SRCC_PREMIUM	4,712,992	A
REINSURANCE_FUND	2,681,897	B
FOREIGN_COMPANIES	773,855	C
CEEDED_PREMIUM	A+B+C
GROSS_CLAIMS	4,643,719	D
CLAIMS_RES_FUND	416,196	E
EXGRATIA_CLIMS_RES_FUND	20,810	F
CLAIMS_PROCESSING_EXPENSES	4,183	G
RI_RECOVERIES_RI_FUND	790,438	H
RI_RECOVERIES_FOREIGN	1,255,153	I
SALVAGE_RECOVERIES	0	J
NET_CLAIMS	D+E+F+G+H+I+J


MANAGEMENT_EXPENSES	4,191,252	K
INV_OTHER_INCOME	-29,038	L

NET_PROFIT	K+L

Re: FIELD SUM

sidhiq91 — Wed, 24 Aug 2022 11:37:09 GMT

@sagaraperera You can use the below set analysis to get the desired output.

1. sum({<DESCRIPTION={'SRCC_PREMIUM','REINSURANCE_FUND','FOREIGN_COMPANIES'}>}ACTUAL)

2. sum({<DESCRIPTION={'GROSS_CLAIMS','CLAIMS_RES_FUND','EXGRATIA_CLIMS_RES_FUND','CLAIMS_PROCESSING_EXPENSES','RI_RECOVERIES_RI_FUND','RI_RECOVERIES_FOREIGN','SALVAGE_RECOVERIES'}>}ACTUAL)

3. sum({<DESCRIPTION={'MANAGEMENT_EXPENSES','INV_OTHER_INCOME'}>}ACTUAL)

If this resolves your issue, please like and accept it as a solution.

topic FIELD SUM in Reporting Service & Alerting

FIELD SUM

Re: FIELD SUM