Skip to Content
0
Former Member
Jan 16, 2008 at 12:00 AM

How to select last record or first record value in a formula?

1612 Views

Post Author: d111

CA Forum: General

I am using a query in a report that in addition to other columns, has a column of month labels like:

There are no unique identifiers or sequence fields that can be used. There is only 4 columns: the label and 3 percent columns.

Jan07Feb07Mar07Apr07etc.

I would like to show the range of months I am using in a label on the report showing the last and first records value. like: "Jan07 to Jun07".

I can not see how to use the functions maximun or minimum since it sorts the months alphabetically.

I would like to use a formula to just grab the first and last record. I can't seem to find any information on this anywhere.

Please advise and thanks.