Reg : Expression Help

[sona_sa]

Hi Friends,

I have two variable : i.e - for Total Collectable Amt and Total Reason Code Amt.

and Twelve Different - 12 Reason Code Amt.

i.e are following :

Reason_Land     

Reason_LD Claim             

Reason_Generation Claim           

Reason_NOC      

Reason_Projects              

Reason_ROW     

Reason_PE          

Reason_Early RR               

Reason_Others 

Reason_Invoice / DCLR  

Reason_RM        

Reason_Fin Closure   

vRCA = Sum(Reason_Land + Reason_LD Claim + Reason_Generation Claim + Reason_NOC + Reason_Projects + Reason_ROW + Reason_PE

+ Reason_Early RR + Reason_Others + Reason_Invoice / DCLR)

vCollectableAmt = Sum (Net Collectable)

Condition is :

1. If (vCollectableAmt > vRCA) and any one Reason Code Amt > 0 then replace that vCollectableAmt to that Reason Code Amt.

2. Else If Check (vCollectableAmt > vRCA) and Reason_RM_Amt = '0' and Reason_Fin_Closure_Amt = '0', then Add the difference of (vCollectableAmt  - vRCA) in the behalf of max( Another 10 Reason Code Amt)

3.Else Check (vCollectableAmt > vRCA) and Reason_RM_Amt <> ' 0' and Reason_Fin_Closure_Amt <> ' 0'  then Add the difference of (vCollectableAmt  - vRCA) in the behalf of max( Another these two Reason_RM_Amt or Reason_Fin_Closure_Amt).

Thanks

Akumar