Susan,
You're on the right track, basically you need 2 formulas:
Formula one called @Age in Days and Formula 2 called Age Blocks
@Age in Days contains the one line: DateDiff ("d", [EMAIL PROTECTED]
Date},[EMAIL PROTECTED]'s Date}) (reported date is merely the reported (or
submit
date converted from Epoch and Today Date is printdate (alternately could
be currentdatetime)
@Age Blocks is the one you're interested in; modify the day values per
your requirements. If you need additional help let me know.
if [EMAIL PROTECTED] in Days} < 7 then "New" else
if [EMAIL PROTECTED] in Days} >= 7 and [EMAIL PROTECTED] in Days} < 15 then "7
days" else
if [EMAIL PROTECTED] in Days} >= 15 and [EMAIL PROTECTED] in Days} < 30 then
"15 days" else
if [EMAIL PROTECTED] in Days} >= 30 then "30 days and over"
Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946
Susan Palmer <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)"
<[email protected]>
06/21/2007 10:36 PM
Please respond to
[email protected]
To
[email protected]
cc
Subject
Need Crystal report guru help - Aged buckets
**
Hi everyone,
I currently have an Aged HT report that puts counts in the standard Aged
buckets that Crystal provides. Works great as you would expect. Now I
have a request to create a report that covers only 30 days but has a
series of 5 day buckets, i.e. 0-5 days, 6-10 days, 11-15 days, etc. Of
course those buckets don't exist in Crystal.
I'm not the greatest on formulas and I've been trying to get my arms
around what the formula would be but I guess I just don't get it. I don't
want to have to put actual dates in. So basically a bucket represents the
number of open tickets and counting how many of them have been open
0,1,2,3,4 and 5 days for the first bucket. So I guess on each row I need
to calculate how many days the ticket has been open. So would that
formula be Today - Date Submitted with the result in days.
So you would end up with a number on each row representing how many days
it's been open. Hopefully this is valid thinking so far.
So how do I get it to count all the 0,1,2,3,4 and 5's at one time to get
the bucket value? I think grouping would be involved but I don't know how
to define that.
The report in general represents the last 30 days and I think there is a
date range parameter I can choose for that to define the selection of
records.
I've looked at the Crystal support site and find some info on Aged but if
it's telling me how to do this I'm not grasping it.
I really need help in simple, basic terms. I've been working on these off
and on for days and have a little brain scarring occurring so please be
gentle.
Appreciate your help in advance .... could be worth a drink(s) at RUG ...
I can bring cheese too!
Thanks,
Susan
Crystal 9
ARS 5.1.2 soon to be 7.0.1P2
Oracle 9i soon to be 10g
Yes my Crystal 9 reports are working on the new versions.
No Crystal server
Use CrystalDesk Scheduler PRO9 and love it
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
