Get value for max(date) which is not null

[obruski10]

Hi,

I need to show the value for the maximal date that is available. Now my problem is I get some values later than other thus max(date) in set analysis is not an option. Further I have some forecast values which means I have values until the end of the year.

How can I now display the most recent value which is not null??

Thank you in advance.

Oliver

[sunny_talwar · Accepted solution]

May be like this:

FirstSortedValue({<value = {'*'}>} value, -date)

or provide a sample if this does not work

[obruski10]

Thank you! Works perfectly.