Print Page | Close Window

Maximum Formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17521
Printed Date: 03 May 2025 at 10:53pm


Topic: Maximum Formula
Posted By: Tobuk
Subject: Maximum Formula
Date Posted: 10 Sep 2012 at 5:32am
Trying to extract or flag the Newest date when each values repeats but also extract/flag when it doesn't
See below. In CR 2008

Values     Dates     Status
GG001014     8/20/2012      Flag
GG001014     7/19/2012      
GG001015     7/9/2012
GG001015     7/11/2012      Flag
GG001015     7/9/2012
GG001028     7/11/2012
GG001028     7/18/2012      Flag
GG001448     8/13/2012
GG001448     8/15/2012      
GG001448     8/16/2012      
GG001448     8/17/2012      Flag
GG001449     8/18/2012      Flag
GG001450     8/19/2012      Flag


-------------
GB



Replies:
Posted By: DBlank
Date Posted: 11 Sep 2012 at 1:56pm
Group on values
Create a formula as
If maximum(date,value) = date then 'Flag'



Print Page | Close Window