cancel
Showing results for 
Search instead for 
Did you mean: 

Display of Max value in a list

bill_coombs
Participant
0 Kudos

I am trying to identify the maximum value from a list, and only display the max value:

Vendor Posting date

Vendor1 08/03/2004

Vendor1 02/22/2005

Vendor1 03/15/2005

Only want to show the last posting date (03/15/2005).

I have moved the posting date into the KF structure by creating a formula variable, and also tried to subtract posting date from current date to determine "number of days", but still don't know how to get the largest value to be returned....any tips?

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188975
Active Contributor
0 Kudos

Hi Bill,

If you are bringing in the date to a key figure (through formula variable), you can try using a condition for Top N (N =1) and make this condition valid for char Vendor.

Hope this helps...