FIELD SUM

[sagaraperera]

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

[sidhiq91 · Accepted solution]

@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.