Skip to Content
0
Former Member
Nov 10, 2011 at 07:45 AM

CONVERTING CURRENCY RATE

31 Views

Hi,

I have a bank report in which transaction is carried out through out the world i.e in different currency

but in the report they want to see the amount of any foreign currency in local currency ( BAD )

i've tried making formula by putting 'IF' & 'THAN' logic for example i want to convert USD in BAD

=If([L01 Currency])="US Dollar"Then([Total Debit Postings]*2.75)

this formula is fine and working ,

but this is for one specific currency

What i want is what ever currency it is showing in the report it should change automatically into local currency (BAD)

like here we are having N number of currencies which depends on the transaction carried out so is there any converter or formula so that it should change the currency automatically.....??

Thank you,