Showing max hi/lo without summarizing
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=22321
Printed Date: 03 May 2024 at 7:51pm
Topic: Showing max hi/lo without summarizing
Posted By: 44magnum
Subject: Showing max hi/lo without summarizing
Date Posted: 05 Jun 2017 at 9:52am
I’ve been trying to create a chart which will look at the difference between Promised and Shipped dates, calculate the difference, then plot the highest and lowest value within a given week. To this point I’ve been miserably unsuccessful and could use some help.
So far, I’ve created a formula subtracting the Shipped Date from the Promised Date and called it Days Early or Late. From there I need to create a chart that will capture only the high and only the low but it seems to be adding every instance in a given week rather than isolating the single highest and single lowest occurrence for that week.
Any help would be very much appreciated.
All the best-
Devin
|
|