Fix Value in Set Analysis

[microwin88x]

Hello,

I have the following expression to get the last Contract Date from the last Year we have available:

MAX({$<YEAR={'$(=MAX(YEAR))'}>}CONTACT_DATE)

What I need is to fix the year to show always the last value, in spite of any Year selection.

So if I select Year = 2017/2016/2015 I should always show the Contract Date for my last available Year.

Do you know how could I do that?

Thank you!!!

[sunny_talwar · Accepted solution]

Try this

Max({$<YEAR={'$(=Max({1}YEAR))'}>}CONTACT_DATE)

[Anil_Babu_Samineni]

May be this?

MAX({1<YEAR={'$(=MAX(YEAR))'}>}CONTACT_DATE)

[sunny_talwar]

Or this

Max({$<YEAR={'$(=Max({<YEAR>}YEAR))'}>}CONTACT_DATE)

[ben_pugh]

If you are wondering why people are using {1} instead of {$}, it would be worth familiarizing yourself with set identifiers.

$ = currently selected values

1 = all values in the data, irrespective of current selections

Set Analysis