Currency

[Anonymous]

I make 2 variables to convert the currency from KWD into $ and €

And the two expressions:

If(Vcur$='$',Sum(Balance02),Sum(Balance02)*Vrate$)

If(Vcur€='€',Sum(Balance02),Sum(Balance02)*Vrate€)

are working fine but separate.

So I need to merge between this two expressions to make 1 Expression, Once I select $ button the currency should changes to $, Once I select € button the currency should changes to €, and Once I select KD button the currency should changes to KD.

for more explanation please check the qvw file.

Best Regards,

Awadah

[avinashelite]

try like this create a inline table for all your currency in the script

Currency:

LOAD * inline

[

Unit

Dollar

Euro

KD

];

Then in the button >go to properties > Action> select in field >choose the field in first(Dollar) > value ..if the button is for Dollar than select Dollar

based on the selection write a if condition in the expression to set the values like

if(getfieldselections(Unit)='Dollar', Sum(Balance02),Sum(Balance02)*Vrate$,

if(getfieldselections(Unit)='Euro' Sum(Balance02),Sum(Balance02)*Vrate€)

)

)

[sunny_talwar · Accepted solution]

Changed some formulas and variables around, see if this is what you want

[Anonymous]

Dear Sunny,

Yes this is what I want thanks a lot 😃