Print Page | Close Window

Formula to display oldest date in a list?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20577
Printed Date: 02 May 2024 at 8:55am


Topic: Formula to display oldest date in a list?
Posted By: BadBoyHouse
Subject: Formula to display oldest date in a list?
Date Posted: 26 Mar 2014 at 12:14am
I’ve created a report which shows a list of dates along with currency values and whether or not the value for that date is unbilled. The three columns are made up of a date field, a currency field, and a variable to determine whether it is an unbilled item.

e.g.

23/09/13 - £100 -
09/12/13 - £100 -
11/12/13 - £100 -
06/01/14 - £100 - Unbilled
27/01/14 - £100 - Unbilled
05/02/14 - £100 – Unbilled
26/02/14 - £100 - Unbilled

I’m having difficulty coming up with a formula that will show the date of the oldest unbilled item.

I would normally use the ‘Minimum’ command to obtain the oldest date however in the example list above, the Minimum/oldest date is 23/09/13 whereas I need the oldest unbilled date which is 06/01/14.

Can anyone offer any pointers as to how I could pick out the oldest unbilled date?

Thanks in advance.


Replies:
Posted By: DBlank
Date Posted: 26 Mar 2014 at 3:46am

depends on the unbilled variable process bu tin general you can use a shared variable formula or a running total with an evaluate condition.

both have to be dislayed in a footer (group or report) to work

Posted By: kostya1122
Date Posted: 26 Mar 2014 at 8:39am
you could create a formula like
maximum(date_field)


Print Page | Close Window