Crystal Reports Crystal Reports 2008

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Crystal Reports 2008
	<< Prev Page of 3

Author

Message

vpriyanka2001
Groupie
Groupie

Groupie

Joined: 28 May 2009
Online Status: Offline
Posts: 59

Quote vpriyanka2001

Reply

Posted: 09 Jun 2009 at 12:11pm

Color is Missing.

Total New Business for Average is Missing.

We got this above average from the formula you gave.

IP Logged

DBlank
Moderator

Moderator

Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053

Quote DBlank

Reply

Posted: 09 Jun 2009 at 12:42pm

I think I see what you want.

You have a group level that has a value of "New Business".

To get the average you need to create a new formula field that will give you the average for the group level and place the formula field in the group footer for that. This should be the same formula that gets your other percentages but replace the group level field in it with whatever the field is that you get the "New Business" result from.

You also may want to test out the two sums (that you are using in the division by) as seperate formulas to see if they are summing correctly. Place them on that same footer to see the values per group level.

If they are not correct are there duplicate records that need to be accounted for?

Edited by DBlank - 09 Jun 2009 at 12:44pm

IP Logged

vpriyanka2001
Groupie
Groupie

Groupie

Joined: 28 May 2009
Online Status: Offline
Posts: 59

Quote vpriyanka2001

Reply

Posted: 09 Jun 2009 at 2:05pm

I think we need separate formula for sum:

Subtotal new Business (red column should have totals for all the above AVG)

Eg AVG total for these should be:(11012)

Average what all numbers you see above we got from the formula.

if Sum({UpLoad_Report_EOM;1.PolicyCount},{UpLoad_Report_EOM;1.ProgramCode}) =0 then 0 else
(Sum({UpLoad_Report_EOM;1.PolicyPremium}, {UpLoad_Report_EOM;1.ProgramCode})
/ Sum({UpLoad_Report_EOM;1.PolicyCount},{UpLoad_Report_EOM;1.ProgramCode}))

I think we need another formula that can sum these up, based on New and Renew Business.

We need to use same formula what is above with adding another group type to it as ({UpLoad_Report_EOM;1.PolicyType})

PRGM - CODE	AVG
NEW BUSINESS
ES	0
HMS-MAIN	897
REIC/RESW	311
REXS	822
RMAX	7,364
RMAXF	0
STD	1,617
Sub Total New Business

PRGM - CODE	AVG
RENEW BUSINESS
ES	0
HMS-MAIN	454
REIC/RESW	775
REXS	822
RMAX	456
RMAXF	88
STD	1,617
Sub Total ReNew Business

IP Logged

vpriyanka2001
Groupie
Groupie

Groupie

Joined: 28 May 2009
Online Status: Offline
Posts: 59

Quote vpriyanka2001

Reply

Posted: 09 Jun 2009 at 2:10pm

For Column AVerage, SUB Total New Business Should come: 11012

and Average, Sub Total Renew Business Should come: 4212

IP Logged

DBlank
Moderator

Moderator

Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053

Quote DBlank

Reply

Posted: 09 Jun 2009 at 2:14pm

Yes. You cannot just sum and the program level and then average it.

Sorry I cannot just give you the formula but it is really hard to understand your table and field names and then know how you have them grouped in the report...

Based on your last commment I think it will be:

if Sum({UpLoad_Report_EOM;1.PolicyCount},{UpLoad_Report_EOM;1.PolicyType}) =0 then 0 else
(Sum({UpLoad_Report_EOM;1.PolicyPremium}, {UpLoad_Report_EOM;1.PolicyType})
/ Sum({UpLoad_Report_EOM;1.PolicyCount},{UpLoad_Report_EOM;1.PolicyType}))

You can also tets each part for your amounts in seperately formulas as I suggested earlier...

Sum({UpLoad_Report_EOM;1.PolicyPremium}, {UpLoad_Report_EOM;1.PolicyType})

and

Sum({UpLoad_Report_EOM;1.PolicyCount},{UpLoad_Report_EOM;1.PolicyType})

to verify these give you the 11012 and 4212 sums you indicated above.

IP Logged

vpriyanka2001
Groupie
Groupie

Groupie

Joined: 28 May 2009
Online Status: Offline
Posts: 59

Quote vpriyanka2001

Reply

Posted: 09 Jun 2009 at 3:05pm

Thanks for all your help,

None of these are working, I tried these earlier too.

IP Logged

vpriyanka2001
Groupie
Groupie

Groupie

Joined: 28 May 2009
Online Status: Offline
Posts: 59

Quote vpriyanka2001

Reply

Posted: 10 Jun 2009 at 5:17am

Thanks, got it.

Edited by vpriyanka2001 - 10 Jun 2009 at 5:33am

IP Logged

<< Prev Page of 3

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.047 seconds.