Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to convert a amount into INR(lakhs,CR),$,EUR
I would suggest you to create a variable with the exchange rate and multiply both
thanx jsanchezh
Do anyone have qvw made of amount conversion?
Re: Best Practice for Currency
hopes helps.
Hi Gaurav,
I would strongly recommend to set up a Currency QVD file.
What we have done is to gather information from an XML provided by the Federal state and create a QVD. this QVD has an automatic reload every month, therefore we are always up to date.
This is the script we use to create the QVD.
devise:
LOAD code,
land_de,
land_fr,
land_it,
waehrung,
kurs,
year,
month
FROM
[\\OTG-QVIEW\Report\Data\devises.qvd]
(qvd);
// recharge de données du taux de change
LOAD code,
land_de,
land_fr,
land_it,
waehrung,
kurs,
$(année) as year,
$(mois) as month
FROM [http://www.afd.admin.ch/publicdb/newdb/mwst_kurse/estv/mittelkurse_xml.php?m=$(mois)&j=$(année)] (XmlSimple, Table is [monatsmittelkurs/devise]);
store devise into \\OTG-QVIEW\Report\Data\devises.qvd (qvd);
As you can see, we get the data and we use STORE to create a QVD file that we can use for any other QVW.
Then, in our main QVW that needed those currency information, we do have this script.
Devises:
LOAD code,
land_de,
land_fr,
land_it,
waehrung,
kurs,
year,
month,
Hash128 (code,year,month) as %Clé_Devise
FROM
[\\OTG-QVIEW\Report\Data\devises.qvd]
(qvd);
Hope this help.
JP