Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Average formula not working Post Reply Post New Topic
Author Message
lahorichick
Groupie
Groupie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 54
Quote lahorichick Replybullet Topic: Average formula not working
    Posted: 24 Sep 2009 at 8:58am
i am working on a report that is grouped by:
 
Name
Invoice. Date (grouped in month)
 
i.e.
John           total job completed 300 <--that's a distinct count.
8/2009                                      250<--that's a distinct count.
9/2009                                        50<--that's a distinct count.
 
I would like to calculate the average for the month....
how would i do that?
IP IP Logged
lahorichick
Groupie
Groupie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 54
Quote lahorichick Replybullet Posted: 24 Sep 2009 at 12:22pm
Ok just in case this wasn't making sense.
 
Group#1 Salesman.Name
Group #2 Invoice.Date (Grouped per month)
Details- Invoice.Date etc.
 
What I would like....
 
G#1: John      Total Invoices     per Month         Per Week          Per day
                             700         350                    88                18       
              
G#2: 8/2009         500     
         7/2009         200
 
Total invoices : distinct count Summary for InvoiceNumbers
 
I can't do an average of a count summary- I tried passing as a variable and then doing the average. Still did not work.
 
Any suggestions. Plz
 
IP IP Logged
Jyothi Yepuri
Senior Member
Senior Member


Joined: 11 May 2009
Location: Australia
Online Status: Offline
Posts: 127
Quote Jyothi Yepuri Replybullet Posted: 24 Sep 2009 at 5:51pm
create formula for month as {@Month}
Totext(DATE({Invoice.Date}),"MM/yyyy")

for Average
DistinctCount ({InvoiceNumber}, { Salesman.Name})/DistinctCount ({@Month}, { Salesman.Name})

Hope gives you idea to calculate for week,day as well

Jyothi
IP IP Logged
lahorichick
Groupie
Groupie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 54
Quote lahorichick Replybullet Posted: 25 Sep 2009 at 5:57am
Thank you for that...
i'm trying to get the per week and per day count but its not working..
 
 
plz help...
 
 
IP IP Logged
lahorichick
Groupie
Groupie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 54
Quote lahorichick Replybullet Posted: 25 Sep 2009 at 6:20am

You had suggested to use:

 

Totext(DATE({Invoice.Date}),"MM/yyyy")
 
but i kept getting a dialog box "A date-time is required here"
 
so for my @month i have:

Totext(({INVOICE.DATE}),"MM/yyyy")
 
it appears to be working fine...i'm trying to do the same for the per week and per day count but thats not working
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.017 seconds.