compare the development of currencies in one line chart

[#1]

Hej,

I would like to compare the development of currencies in one line chart. i have historical data available:

Date | EUR.USD | EUR.GBP | EUR.AUD

My idea was to use the function "firstSortedValue" like this in my formulas for all the three formulas:

EUR.USD/firstSortedValue(EUR.USD)

But this approach does not work. No data shown.

What am I doing wrong?

Thank you for your help,

Sebastian

[swuehl]

Though the HELP says the sort weight is optional (at least this is indicated by the [] brackets), I believe it isn't.

So you need to give a second argument with the sort weight you want to use.

But maybe there is an easier option, if you're expression values are already sorted by Date (to see the correct development over time) you should be able to address the first value using top() chart inter record function:

= only(EUR.USD) / top( only(EUR.USD))