conversion of column data to dollars to rs

[Anonymous]

Hi

I want to change to quanttity recieved and quantity sold  column value from dollar to rupess. how to do that?

Please help

[Anil_Babu_Samineni · Accepted solution]

May be this?

Sum(Quantity_rec) & 64.09

OR

Expression * 64.09 (Here, 64.09 is today's rate)

[its_anandrjs]

Introduce single inline table

CurrencyTab:

Load * inline

[

Sign,CurValue

Dollar, 65.65

];

and when doing the calculation select Sign >> Dollar in list object

=Sum( Sales ) * CurValue

[Kushal_Chawda]

You need conversion rate from USD to Rupees, then you can try like below

=sum(Quntitysold)*conversionRate

[its_anandrjs]

In this way you make it dynamic and change the dollar value to new values and you can add many currency value also

Ex:-

CurrencyTab:

Load * inline

[

Sign,CurValue

Dollar, 64.08

Pound, 84.71

];

[avinashelite]

if you want the converter point in time then better to store the conversation rates for each day and use for converting the history data ...if its as of today you could go with simple   =Sum( Sales ) * 64.08