Running Total of Group fields. ?????? 1

[joethehoe]

Crystal 8.5 Running total fields.

Is there a way to create a conditional running total from the group footer totals instead of the details section.

When I try to select a group sum its telling me (invalid section)

Thanks
Joe

 

[rosemaryl]

Dear Joethehoe,

What exactly are you trying to do?

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[joethehoe]

PH: Date Week day(number) Week day(name) Dials
GH1: AGE1
GH2: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\GF2: 2002/12/08 1 sunday 666
GF2: 2002/12/09 2 Monday 123
GF2: 2002/12/10 3 Tuesday 123
GF2: 2002/12/11 4 Wednesday 123
GF2: 2002/12/12 5 Thursday 123
GF2: 2002/12/13 6 friday 123
GF2: 2002/12/14 7 Saturday 123
GF2: 2002/12/15 1 sunday 888
GF2: 2002/12/16 2 Monday 123
GF2: 2002/12/17 3 Tueday 123
GF1: Total Age dials 2538
GF1: Average Monday 777

I have 30 day report that's grouped age and then by date (ascending). I can do running total by day of the week ( I.E. Monday or Tuesday) That's sums all the Mondays into a total. But what would like to do is average by group (GF2). When change the sum field to average its taking from the details section. and of course when try to change field to summarize to group total, it tells me invalid field selection.

 

[rosemaryl]

Is the Dials group total the sum of a database field or is it a running total?

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[joethehoe]

Data base field

 

[rosemaryl]

Joethehoe,

Okay, my initial thought is why doesn't this work for you:

average(Table.Dials,Table.Datefield)
//Use the datefield for Group2

If you put that in the Group Footer 1, you will get the average value of dials by the group2. Is this what you were looking for?

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[joethehoe]

average(Table.Dials,Table.Datefield)

average ({Combined Call Statistics.Calls Placed}, {General Information.Job Run Date})

Thanks but it is still doing average of details sections.

I was hoping for average the (gf2: dials)

day dials
GF2: friday 94047
GF2: Saturday 53164
GF2: Sunday 93088
gf1: average 80099 should be the average for the group total

Thanks
Joe

 

[rosemaryl]

Hi,

Okay, well the thing is I am looking at your data and group 2 is not the day of the week but the date because the days repeat in group 2. Is that right? or am I missing something.

ro
Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[joethehoe]

Exactly, GF2: is by date ascending.

 

[rosemaryl]

Joe,

Okay, my brain must have not been in gear, because I just now get what you want now. I'm usually better than that - I plead heavy-duty cold medication.

What you need is to divide the total sum of dials by the number of groups in Group2.

Create a running total: Grp2Cnt
Insert Running Total
Summary - Field to Summarize Table.Date Field in Group2
Evaluate - For Each Record
Reset - On Change of Group 1 Field


You need to do a manual average:

Sum({Table.Dials},{Table.Group_1_Field) / Grp2Cnt

Place that field in Group Footer 1.

This should do it. Takes the sum of the dials for Group 1 and divides by the number of groups in Group 2.

Hope that is right and that it is what you are looking for. Sorry for the misdirection in the beginning.

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[joethehoe]

Not a problem, ive been trying to figure this out for weeks.

I will try this tommarow and thanks for being so helpfull.