Skip to Content
0
Mar 23, 2018 at 12:18 PM

Formula to find the record with the largest value in a field

305 Views Last edit Mar 23, 2018 at 12:21 PM 2 rev

Hi all,

I am working with "SAP BusinessObjects Business Intelligence 4.2" and have the following problem.

The table I am working on consists of several objects.

One of them is the object called "INM NOTICE NoticeNr" and its values look like this:

000000525192664
000000525152208
000000525152207
000000525152206
000000525152205
000000525152204
000000525152203
000000525152202
000000525152201
...

I do just need the dataset with the biggest value in the field "INM NOTICE NoticeNr".

How can this be done?
Any ideas?


Thanks for your help!
Henning