Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Avarage Difference Post Reply Post New Topic
Author Message
venky_115
Groupie
Groupie
Avatar

Joined: 15 Jun 2010
Location: United States
Online Status: Offline
Posts: 67
Quote venky_115 Replybullet Topic: Avarage Difference
    Posted: 13 Jul 2010 at 8:08pm

Hi
I am taking avarage of two fields in a group header, i want to display the difference of those two avarage fields beside those columns i am not getting how to do pls help me

Regards
Venkat

Regards
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 14 Jul 2010 at 1:34am
can you give us an example?
so we can play w/ it.
Emir W
IP IP Logged
venky_115
Groupie
Groupie
Avatar

Joined: 15 Jun 2010
Location: United States
Online Status: Offline
Posts: 67
Quote venky_115 Replybullet Posted: 14 Jul 2010 at 7:16pm

I have two amount fields in the details, i am taking the avarage of those two and placing at in group header, now i want to take the difference of these two avagrage values, i have written a formulae but it is not working properly.

for eg:

positions      totalrevenue  totalctc     customer

2                         2000$        1500$    abc

1                         3000$         2800$   xyz

50                      30000$        25000$  abc

7                        900$             750$     pqr

so i want to take avarage of total revenue and totalctc, also need difference of those avarage values in groupheader i.e in customer group
 
Thanks
 
Regards
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 14 Jul 2010 at 7:40pm
in this case you have created a formula to get the average for each field (let's say revavg and ctcavg), right?
 
then, create another formula (allavg) to get the average from the other formulas (revavg and ctcavg).
so, it will be something like:
(revavg + ctcavg)/2
 
and put it in the header section.
 
 
hope it help.
 
Emir W
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.031 seconds.