Post Author: MartinC
CA Forum: Formula
Hello!
I'm trying to display the first and last record of a datetime field. I'm using the Maximum and Minimum fonctions. I am able to display the first and last record but the associated fields are wrong. Here's what I mean...
The fields in the report are the following...
MRN AssesmentDate Score1 Score2 Score3
10 Dec 20th, 2007 2 3 3
11 Dec 1st, 2007 1 1 2
12 Dec 15th, 2007 3 3 3
What I want to appear in the report are the following fields...
10 Dec 20th, 2007 2 3 3
11 Dec 1st, 2007 1 1 2
but I get
10 Dec 20th, 2007 2 3 3
11 Dec 1st, 2007 2 3 3
As you can see, the score fields for the Minimun display the Maximum fields.
Thanks in advance!