on 05-18-2006 4:53 PM
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
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.