Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this:
FirstSortedValue({<value = {'*'}>} value, -date)
or provide a sample if this does not work
May be like this:
FirstSortedValue({<value = {'*'}>} value, -date)
or provide a sample if this does not work
Thank you! Works perfectly.