Forex Inverse Issue

[tracycrown]

Dear all

Kindly help to advise the following issues :

1. How to keep the answer in Table 1 as it disappears after clicking Euro currency ?

2. Have problem in getting the correct answer as Table 2 in Excel.

Thank You Very Much

Tracy

[francoiscave]

Hi Tracy,

See the attached file to get the solution.

It's what do you expect ?

Best regards,

François

[Gysbert_Wassenaar]

See attached qvw. Is that what you mean?

[tracycrown]

Dear François

Thanks for your quick response and help.

You have answered the 1st question but not the 2nd one, The answer for the 2nd one is shown in the Excel worksheet called "Answer").

Thank You

Tracy

[tracycrown]

Dear Gysbert Wassenaar

Many thanks for your help and quick response.

The answer is correct but can you explain why there is a fixed date in sum({<Date={'01-01-15'}>}Data) in vCurr. Can I have some flexibility ?

Thank You

Tracy

[Gysbert_Wassenaar]

Because you do the same kind of thing in the excel file. If you want flexibility you can use a variable instead of the fixed value.

[tracycrown]

Dear Gysbert Wassenaar

Sorry, it is my mistake, I have changed from fixed to variable in the revised worksheet.

Kindly advise how to change the script and allow me to choose any currency (not just Euro).

Thank You

Tracy

[Gysbert_Wassenaar]

Click on a currency value to select it.

[tracycrown]

Dear Gysbert Wassenaar

I know I have to select the currency but how to change the vCur to cater for all dates instead of fixed date '01-01-15'.

Thank You

Tracy

[Gysbert_Wassenaar · Accepted solution]

See attached qvw