Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Currency Conversion handling in FM model

Status
Not open for further replies.

asini

Technical User
Nov 13, 2008
22
US
Hello All,


Can any one give me an idea to handle currency conversion.

in my source DB i dont have 1 table which structures as CurrencyFrom, CurrencyTo,Rate columns.(in this table we used to hole only current rate)

and one table call transacts (it has all debit,credit,conversuion,currency,etcc)

now i added currency table to my model and transaction as well, created relationship with Currency in trans and CurrencyFrom in Currency table
in the model itself, in query subject i created a filter as always, #prompt('enter country to convert','string')#

then in trans query subject i created Amount Converted, and definition as --> round(trans.amount*Currency.ToCurreny,2)

so when ever a user drags this amountconverted column to report in report studio and run the report user will be prompted to enter which currency he wants to see the results

so far everything is fine (usually our reports are comparing to previous year balance with current year).

now as per our new requirement from our end user,
now it needs to store each day rate in one table(we will manage it),

how can i handle (what can i do in FM model) to handle, user have opportunity to calculate conversionamount based on last year currency rate or present currency rate

when ever user try to creare a report, then it needs to show a prompt to select last year rates is calculate as last year conversion rates so how can we handle it

Please help me in regards

your ideas more valuable to me
asini
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top