Dear all,
I have the monthwise data, i need to show the monthwise ytd amount multiplied by the exchange rate of the specific month.
for ex,
CID Cureency MonthYear Amount
100 USD Jan-2007 200
100 USD Feb-2007 600
100 USD Mar-2007 400
100 USD Apr-2007 300
100 USD May-2007 100
200 EUR Jan-2007 100
200 EUR Feb-2007 200
200 EUR Mar-2007 300
200 EUR Apr-2007 500
200 EUR May-2007 600
300 INR Jan-2007 100
300 INR Feb-2007 200
Exchange rate
MonthYear Currency Rate
Jan-2007 USD 50
Feb-2007 USD 45
Mar-2007 USD 52
Apr-2007 USD 50
May-2007 USD 45
Jan-2007 EUR 60
Feb-2007 EUR 65
Mar-2007 EUR 55
Apr-2007 EUR 60
May-2007 EUR 70
Jan-2007 INR 1
Feb-2007 INR 1
Mar-2007 INR 1
Apr-2007 INR 1
May-2007 INR 1
output(INR)
CID monthyear cum.amount
100 Jan-2011 200*50
100 Feb-2007 (200+600)*45
... .
. '''
.
