INR calculation

[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.

[#2]

You can Maintain an Excel in format [From Date] , [To Date],Rate .

and using interval match you can apply the rate to your order price in your scripting.

Himank