Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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))