Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have straight table..in that i am calculating INR for USD as sum([Order Price])*60.04.
But the $ value is not constant as 60.04 i will change in future...how to get that value automatically to calculate.
Can anyone help me.
Regards,
Rathnam.
You can upload Dollar rate using WebSite We can pick us rate and do calculation on this directly in Qv.
Vikas
It depends on how often u reload the application. If it is daily then u will have to fetche the daily rates from internet and put it in the variable place. If it is monthly then u will have to use the average for the month as the $ rate. now the thing is how u get the $ value of all the days, this u cn get it from any standard web sites like BLOOMBERG. U would need to connect with them to have the monthly data.. Pls let m,e know how often will u relaod the dashboard.
-Sundar
Hi Sundarakumar,
Thanks for your reply.
reload happens on every day.
Regards,
Rathnam.
Check and use this...
Hi,
Then its very easy, u cn fetch the data form the web site directly as another field and use the specific field for the variable that i have specified above. I think Blooomberg would be a best example. U ahve many other sotes which show the currency details.
Hope this helps.
-Sundar
Your order price would definitely belongs to some order number which have some order date..
Try to create another table with Date and USD and INR rate.
Now rename the Date or Rate table as order date and calculate accordingly...
Another option is to link Date and USD/INR rate from web site so you dont have to manually keep record of date vs rates...
Hi Manish,
Thanks for ur reply.
can u please send me sample app
if you can send your sample data with different rates, will try to create apps for you.
hi Hope this attachment helps you !
-Many Thanks
Premhas