

Contributor II
2016-07-22
08:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Get value for max(date) which is not null
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
2,389 Views
1 Solution
Accepted Solutions

MVP
2016-07-22
10:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this:
FirstSortedValue({<value = {'*'}>} value, -date)
or provide a sample if this does not work
2 Replies

MVP
2016-07-22
10:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this:
FirstSortedValue({<value = {'*'}>} value, -date)
or provide a sample if this does not work


Contributor II
2016-07-26
07:17 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you! Works perfectly.
1,858 Views
