Handling Currency Table

[#1]

Hi All,

I have a currency table with 2 currency columns, 1 with AUD and other with NZD conversion rates.

I would like to create a list box with values AUD and NZD and when user selects AUD I want to calculate sales * AUD column and when user selects NZD I want to change the calculation to Sales * NZD in the chart list.

Could you please advice best approach to achieve this.

Thanks,

MC

[tresesco]

Try to use system field $Field. To evaluate the values you might try writing expression something like:

=Sum(Sales * $(=$Field) )

$(=$Field) -> will get the NZD/AUD values as per selection.

[jagan]

Hi,

Try this expression

=Sum(Sales * If(Only(Currency) = 'NZD', NZD, AUD))

** Where Currency is the dimension which is having NZD and AUD to select the currency

Regards,

Jagan.

[#4]

Thank you tresesco ..If possible can you please send me an example for the same? How to assign $Field to listbox?

[Karthik3]

The best way is to do this calculation in the script itself. You will be having two fields in the script one for AUD and one for NZD.

[Sales Value AUD] =  Sales*AUD

[Sales Value NZD] =   Sales*NZD

Create an Inline table in script with field currency and values AUD and NZD.

In a list box display this currency field and check 'always one selected value'

In chart then use the following expression:-

PICK(MATCH(Currency, 'AUD', 'NZD'), [Sales Value AUD], [Sales Value NZD])