Error in Set expression

[nevilledhamsiri]

Dear Experts!

My issue is this.

I have linked refunded policies with refunded GL transfer balances. The link was basically with Credit note no. I need following conditions to be met & once it is met to compute Rs 250/= for all such cases.Followings are my conditions,

Class code= MC, M4

Reasons=Customer request

Premium< CR_PREMIUM

then to calculate Rs 250/=

To incorporate above,  I have applied following set expression but it doesn't produce expected results. Can my dear friends to look in to this & see where I have gone wrong!

SUM({<REASON={'CUSTOMER REQUEST'},CLASS_CODE={'MC','M4'},PREMIUM ={"=PREMIUM>CR_PREMIUM" }>}250)

Regds

Neville

[nevilledhamsiri]

Dear Tom Hoch,

You proposed two expressions out of one which  carries value calculation for each row is what I needed. The P/T obtained is as follows. Thank you a lot.

Mr Vishwarath,

Must be thankful to you as well. You proposed some expressions as well as how the script to be arranged that too help me to take that knowledge & skills to my other issues as wee. Thanks very much for giving me the helping hand from the out set.

Mr Aravind

You too are thanked a lot for your response.

Then dear Anil, you being a one who help always should be thanked for inquiring further hep.

Thanks a lot all of my dear friends.

Best Regards

Neville