Expression

[upaliwije]

Hi Friends

Can someone pls correct my following expression

sum(if(isnull(DESC) and Count(CLAIM_NO)>0,PREMIUM,AMOUNT))

[Anonymous]

Hi,

try:

script:

if(len(trim(CLAIM_NO)) = 0, 0, CLAIM_NO) as  CLAIM_NO

UI:

if(len(trim(DESC))>0 and CLAIM_NO <>0, sum(PREMIUM), sum(AMOUNT))

[upaliwije]

Thanks for your help. But the result is the same. Can u pls think of condition with policy Period?

[PrashantSangle]

Hi,

If possible post sample app, without it difficult to give answer.

Regards

[marcus_sommer]

Have you checked if the result is the sum of PREMIUM or from AMOUNT then the expression returned in every case a sum-function. I suggest you put each part from the expression in a single expression-column to see what each returned and the to decide if this are the expected results and then put them together again.

- Marcus

[upaliwije]

AMOUNT	CLAIM_NO	PAID_AMOUNT	DESC	POLICY_NO	POLICY_PERIOD	PREMIUM	RISK
	CLGN001A15000036	4000		GN00111A0000119	Aug-14 - Aug-15		17-6819
	CLGN001A15000023	12200		GN00111A0000119	Aug-14 - Aug-15		17-6819
	CLGN001A15000063	6500		GN00111A0000119	Aug-14 - Aug-15		17-6819
	CLGN001A15000063	6700		GN00111A0000119	Aug-14 - Aug-15		17-6819
	CLGN001A15000021	4500		GN00111A0000119	Aug-14 - Aug-15		17-6819
	CLGN001A15000021	12500		GN00111A0000119	Aug-14 - Aug-15		17-6819
1200			SRCC TO VEHICLE	GN00111A0000119	Aug-12 - Aug-13	14505	17-6819
1200			SRCC TO VEHICLE	GN00111A0000119	Aug-13 - Aug-14	13805	17-6819
1200			SRCC TO VEHICLE	GN00111A0000119	Aug-14 - Aug-15	13105	17-6819
1200			SRCC TO VEHICLE	GN00111A0000119	Aug-15 - Aug-16	15205	17-6819
1400			FLOOD COVER AND  NATURAL PERILS	GN00111A0000119	Aug-12 - Aug-13	14505	17-6819
1400			FLOOD COVER AND  NATURAL PERILS	GN00111A0000119	Aug-13 - Aug-14	13805	17-6819
1400			FLOOD COVER AND  NATURAL PERILS	GN00111A0000119	Aug-14 - Aug-15	13105	17-6819
1400			FLOOD COVER AND  NATURAL PERILS	GN00111A0000119	Aug-15 - Aug-16	15205	17-6819
-3500			NO CLAIM BONUS	GN00111A0000119	Aug-14 - Aug-15	13105	17-6819
-3500			NO CLAIM BONUS	GN00111A0000119	Aug-15 - Aug-16	15205	17-6819
14000			BASIC PREMIUM	GN00111A0000119	Aug-12 - Aug-13	14505	17-6819
14000			BASIC PREMIUM	GN00111A0000119	Aug-13 - Aug-14	13805	17-6819
14000			BASIC PREMIUM	GN00111A0000119	Aug-14 - Aug-15	13105	17-6819
14000			BASIC PREMIUM	GN00111A0000119	Aug-15 - Aug-16	15205	17-6819
5			ROAD SAFETY FUND	GN00111A0000119	Aug-12 - Aug-13	14505	17-6819
5			ROAD SAFETY FUND	GN00111A0000119	Aug-13 - Aug-14	13805	17-6819
5			ROAD SAFETY FUND	GN00111A0000119	Aug-14 - Aug-15	13105	17-6819
5			ROAD SAFETY FUND	GN00111A0000119	Aug-15 - Aug-16	15205	17-6819
0			FREE HEALTH COVER	GN00111A0000119	Aug-14 - Aug-15	13105	17-6819
0			FREE HEALTH COVER	GN00111A0000119	Aug-15 - Aug-16	15205	17-6819
2100			ADDITIONAL LOADING 1	GN00111A0000119	Aug-15 - Aug-16	15205	17-6819
-2800			NO CLAIM BONUS	GN00111A0000119	Aug-13 - Aug-14	13805	17-6819
-2100			NO CLAIM BONUS	GN00111A0000119	Aug-12 - Aug-13	14505	17-6819 !