Minimum Date from Date Range
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22598
Printed Date: 28 Apr 2024 at 7:56pm
Topic: Minimum Date from Date Range
Posted By: mtapp
Subject: Minimum Date from Date Range
Date Posted: 15 May 2018 at 1:43am
I have a formula that pulls in data based on the date the event went to a status of 33.(10/01/2017-10/31/2017). However if someone makes a mistake and changes the status twice during the date range I entered it is being picked up twice and doubles the $ amount. Is there a way to only pull the data based on the MINIMUM date from the range?
Current data returned:
Date went to 33 status name amount unique id
10/1/2017 to 33 mmt $1,000 123
10/15/2017 to 33 mmt $1,000 123
$2,000
Results wanted:
10/1/2017 to 33 mmt $1,000 123
$1,000
Thank you
|
Replies:
Posted By: kevlray
Date Posted: 15 May 2018 at 4:43am
There is a round about way of doing it. I assume that there is some sort of account number you can group on. If so then you can group on the Date and either in the Group Header or Group Footer (depending how you sort the group) show the 'details' and hide the detail line. Thus you will only show the minimum date.
|
|