Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to change to quanttity recieved and quantity sold column value from dollar to rupess. how to do that?
Please help
May be this?
Sum(Quantity_rec) & 64.09
OR
Expression * 64.09 (Here, 64.09 is today's rate)
May be this?
Sum(Quantity_rec) & 64.09
OR
Expression * 64.09 (Here, 64.09 is today's rate)
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
You need conversion rate from USD to Rupees, then you can try like below
=sum(Quntitysold)*conversionRate
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
];
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