My Appoligises to all, who felt i am rude, i am still a learner and this forum helped me a lot to learn many new things and build up my...

Wow, this worked....

Thank you all for providing the solution as well as for explanation, which was helpfull to great extent.

As i am working on other important task, i cannot post it right away, i will try to post that before 20th of this month.

Thanks to all, the issue has resolved and i am sorry as i could not reply at the same time.

I have a column called type, by which i can take the required exchange rate, i am getting my desired result, i need to cross check the data for...

Thanks for all your support.

Thanks for the support, it is working fine when it is a hardcoded value but in my case i hardcoded it for the test, if cyear is passed as...