Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 rathnam_qv
		
			rathnam_qv
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
 vikasmahajan
		
			vikasmahajan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You can upload Dollar rate using WebSite We can pick us rate and do calculation on this directly in Qv.
Vikas
 
					
				
		
 sundarakumar
		
			sundarakumar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 rathnam_qv
		
			rathnam_qv
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Sundarakumar,
Thanks for your reply.
reload happens on every day.
Regards,
Rathnam.
 
					
				
		
Check and use this...
 
					
				
		
 sundarakumar
		
			sundarakumar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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...
 rathnam_qv
		
			rathnam_qv
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Manish,
Thanks for ur reply.
can u please send me sample app
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		if you can send your sample data with different rates, will try to create apps for you.
 
					
				
		
 preminqlik
		
			preminqlik
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		hi Hope this attachment helps you !
-Many Thanks
Premhas
