Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: udana on 21 Jan 2008 04:46:50 AM

Title: Selecting the field pertaining with the max date field
Post by: udana on 21 Jan 2008 04:46:50 AM
Dear all,
I need to find a field value(field1) which pertain to the latest date(field2)....
all these fields are in the same table...
the data stream is given bellow.... the maximum date's value should be taken as the result

field2                field1
01/10/2008   30,081.12
01/10/2008   18,048.67
01/10/2008   120,324.48
01/11/2008   0
01/11/2008   50.14
1/14/2008   421,135.68
1/16/2008   60,162.24
1/16/2008   30,081.12
1/17/2008   60,162.24


thanks in advance
Title: Re: Selecting the field pertaining with the max date field
Post by: almeids on 23 Jan 2008 03:13:09 PM
Won't the filter [field2]=maximum([field2]) do it?
Text only | Text with Images