Need 'If' help !!!

[ajaykumar1]

Hi Everyone,

I have the small req like below and attached the sameple data as well and i have to develop the same at design level.

If ACTUAL BALANCE is -ve then we have to replace with 0 for all the products.

If PRODUCTS FD/RD have blank then we have replace TARGET BALANCE by ACTUAL BALANCE along with the above condition.

The sample output has been attached.

Thanks,

Ajay

[ajaykumar1]

Thanks Venkat and Anand...Its working.