Retrieve most recent date 1

[gj0519]

I have a range of numbers that have a score and date for each number. I have grouped by number, and I am now wanting to get the most recent date and score for that number. I have tried Maximum(Date), but run into problems, so I started looking at using the Previous() function. Not sure how I would write the formula, or if I am going in the right direction. Any Ideas?

Number Score Date
123 56 10/01/2004
123 65 12/29/2004
1234 50 10/01/2004
1234 52 11/13/2004

Thanks,

Glenn

 

[synapsevampire]

State specifics, "I have tried Maximum(Date), but run into problems" doesn't explain what the problem is.

To get the maximum for each number try a formula akin to:

maximum({table.score},{table.number})

-k

 

[gj0519]

Sorry,
Should have been more clear.
I would just use Maximum({table.date}) this would give me obviously the maximum of all dates. I just tried something similar to what you wrote.
Maximum({table.date},{table.number}) and this is working for me.

Thanks,

-Glenn

 

[7jennyh]

I'm trying to get the most recent date for a client, and have tried the formula

maximum ({table.date}, {table.clientref})

but I get
'A boolean is required here'

does this mean that the field isn't formatted as a date? or am I barking up the wrong gum tree?

 

[Madawc]

Right-click on the field, choose Insert and then Summary. Create the maximum directly.


Madawc Williams (East Anglia, UK)

 

[7jennyh]

thanks very much - it worked!