Set Expression for the expected output

[nevilledhamsiri]

Dear All,

I need a set expression to be written for the last record (RA001A0000030).  This is how it was possible on a simple if statement such as ......IF([B/B/F]<500000 AND [B/B/F]+ADJUSTMENT>500000,[B/B/F]+ADJUSTMENT-500000)). Any idea please?

Thanks

Neville

CLAIM NUMBER	CLASS	B/B/F	PROVISION	PAID	ADJUSTMENT	B/C/F
RA001A0000025	MC	-	600,000	-	-	600,000
RA001A0000027	MC	600,000			150,000	750,000
RA001A0000028	MC	1,000,000			(300,000)	700,000
RA001A0000029	MC				600,000	600,000
RA001A0000030	MC	250,000			300,000	550,000

[QFabian]

Hello @nevilledhamsiri , i tried yor qvw, and this expression works fine, please try it :

if(column(1) < 500000 and (column(1)+column(3))>500000,(column(1)+column(3)-500000))