I currently have a report that is grouped by Property.Id, Building.ID,Leased.ID and I want to pull the minimum newdate by leased.id where field4 equals "Yes"
i Tried minimum({Option.newdate},{Leased.ID}) which gives me the correct minimum date for the Leased.ID but I need to take it one step further and have it look for the minimum by where field4 equals "yes" So the data would be as below
Leased.ID NewDate Field4
12345 10/01/2011 Yes
12345 09/01/2011 maybe
12345 08/01/2011 no
12345 12/01/2011 yes
I would like the data returned to b e 10/01/2011
Any suggestions would be greatly appreciated and if this is not the place to post these types of questions please let me know as I am new to this forum.
i Tried minimum({Option.newdate},{Leased.ID}) which gives me the correct minimum date for the Leased.ID but I need to take it one step further and have it look for the minimum by where field4 equals "yes" So the data would be as below
Leased.ID NewDate Field4
12345 10/01/2011 Yes
12345 09/01/2011 maybe
12345 08/01/2011 no
12345 12/01/2011 yes
I would like the data returned to b e 10/01/2011
Any suggestions would be greatly appreciated and if this is not the place to post these types of questions please let me know as I am new to this forum.