Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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