Currency Calculation

[rathnam_qv]

Hi All,

i have straight table in that i have 4 fields Sales Amount,Discount Amt,Quantity Billed,Ontime Deliverd Revenue...which are having $ values.my requirement is to create two buttons as USD and INR in the sheet.when i click on INR it should display INR value in the above mentioned fields.

can any one help me.

Regards,

Rathnam.

[MK_QSL]

Create a Variable vCUR and set value as 1

Now Create two buttons

one for USD

Set Action as
External >> Set Variable

Variable       vCUR

Value           1

Same way make another button for INR and use value as 2

Now in your expression... use vCUR as below

Example

SUM(Quantity * Price * if(vCUR = 1, USDRate,INRRate))

[its_anandrjs]

Update :- Please check now a new update

Create a inline table like

Eg:-

Load * inline

[

CurrencyName, CurrencyRate

USD,1

INR,2

];

Then in the dashboard plot a list box with field CurrencyName and remove its caption from properties

SUM(Quantity * Price * Getfieldselections(CurrencyRate))

then according to your selection in the currency your sum value change.

[rathnam_qv]

Hi Manish,

Thanks for your replay,

now i created one list box with USD,INR and i made them as Radio buttons.now, if i select USD radio button the USD value should change to INR and vice versa in the Straight table.

help me out.

Regards,

RAthnam.

[rathnam_qv]

Hi Anand Chauhan,

Thanks for ur reply..

Ya i already created List box as u suggested.Now if i select INR from the listbox The USD values in the Straight table should display the INR values ad vice Versa (in my straight table 4 fields are there with USD values)

help me out.

Regards,

Rathnam.

[MK_QSL]

Can you post your sample data file or sample apps?

[its_anandrjs]

After adding list box in the application named CurrencyName which contains INR and USD then

in expression write

=if(GetSelectedCount(CurrencyName)=0,Sum(Sales), if(GetSelectedCount(CurrencyName)='INR',sum(Sales) * 1 , Sum(Sales) * 2))

In place of 1 and 2 put currency rates

[nizamsha · Accepted solution]

look at The Attachment

[rathnam_qv]

hi Nizam,

i didn't get any attachment

[nizamsha]

I already attached sme changes  is made and updated