Using a calculated value to link to data

[#1]

Hi:

I have a chart where I am calculating an average from the data returned, using:

=ROUND(RangeAvg(

FirstSortedValue({$<1_RATINGDATE={"<=$(=cal_RATINGDATE)"}>}  1_RATINGVALUE, -1_RATINGDATE),

FirstSortedValue({$<2_RATINGDATE={"<=$(=cal_RATINGDATE)"}>}  2_RATINGVALUE, -2_RATINGDATE),

FirstSortedValue({$<3_RATINGDATE={"<=$(=cal_RATINGDATE)"}>}  3_RATINGVALUE, -3_RATINGDATE)

))

Lets say this returns the value 5.

I then would like to look up a corresponding value in a table using the result:

RTNG_BUK	RTNG_COMP	VALUE
A	A	6
A	A-	7
A	A+	5
AA	AA	3
AA	AA-	4
AA	AA+	2
AAA	AAA	1

when I use

=only({<VALUE={5}>} RTNG_COMP) I get the correct corresponding value, however when I substitute the above formula for the 5 it does not work.

Any ideas?

[hic]

The data model (and the links) cannot be changed by user selections. It must be defined in the script. So your formulae using set analysis must be re-written using if() functions or where-clauses, and put in the script. Then it will work.

But it will not be sensitive to user selections.

HIC