cancel
Showing results for 
Search instead for 
Did you mean: 

condition on a characteristic

Former Member
0 Kudos

Hi

I have a report that I need to display only the latest created on date of a document, some documents have 10 created on dates and some have less.

Is it possible to create a condition on a characteristic, like the TOP N=1?

Any suggestions? This are exemples of my created on dates.

<Removed>

Sold-to party Created on

4501009 12/17/2008

8/28/2007

2/13/2006

6/14/2005

8/13/2004

9/25/2002

10/26/2001

8/28/2000

11/25/1999

8/21/1999

4501029 4/6/2009

9/11/2008

4/8/2008

Edited by: Arun Varadarajan on Apr 30, 2009 11:33 PM

Accepted Solutions (1)

Accepted Solutions (1)

former_member184494
Active Contributor
0 Kudos

else have another KF into which you can fill in the date in the update rules / transformation and then set its aggregation to Maximum - this is if you are on 3.x and not on 7.0. Use this in your query.

Answers (1)

Answers (1)

former_member184494
Active Contributor
0 Kudos

try creating a formula variable with replacement path and set the aggregation to maximum ?? and display the same as date..

Former Member
0 Kudos

Can you please explain in a bit more detais?

Thanks

Former Member
0 Kudos

Hi,

Just create a replacement path variable using date, and use it in calculated key figure, with agregation maximum. and use it in Query as a keyfigure.

Regards,