Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Moving Point Average Post Reply Post New Topic
Author Message
CAWA
Newbie
Newbie


Joined: 16 Jun 2009
Location: Australia
Online Status: Offline
Posts: 7
Quote CAWA Replybullet Topic: Moving Point Average
    Posted: 17 Jun 2009 at 4:06pm
I am using crystal v9.
I need to chart the moving point average for a period of 15 points.
The data is pretty straight forward - ie
 
Sample No               Result           Moving Point Average
1                                   20                       20
2                                   28                       24 (Average of S1+S2)
3                                   10                       19 (Average of S1+S2+S3)
4                                   18                       19 (Average of S1+S2+S3+S4)
.                                     .
.                                     .
.                                     .
.                                     .
.                                     .
15                                 50                         16 (Average of S1...S15)
16                                 62                         18 (Average of S2....S16)
17                                 33                         21 (Average of S3...S17)
 
 
Can anyone help with the code to do this and how to chart both the result and moving point average on one chart.
ThanksTongue
 
 
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Jun 2009 at 4:46pm
I do not have crystal in front of me to test it but I think you can do a running total on the result field set as an average and place it on the detail row...

Edited by DBlank - 17 Jun 2009 at 4:47pm
IP IP Logged
CAWA
Newbie
Newbie


Joined: 16 Jun 2009
Location: Australia
Online Status: Offline
Posts: 7
Quote CAWA Replybullet Posted: 17 Jun 2009 at 6:55pm
Yes if you want a continuous running total , but if it is only an average of the last 15 results - how do you do that?
Thanks
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Jun 2009 at 9:29am

Sorry for the delayed response and not reading the post clearly enough. I was thinking you would reset it after 15 records but it is not every 15 records but the last 15 records which is obviously a much more confusing process. I just keep getting stuck on how to reset it...maybe an array would work...?

Anyone else have thoughts on how to do this one?
IP IP Logged
CAWA
Newbie
Newbie


Joined: 16 Jun 2009
Location: Australia
Online Status: Offline
Posts: 7
Quote CAWA Replybullet Posted: 25 Jun 2009 at 8:26pm
I am still stuck on this and really need to come up with something.
Has anyone got any ideas
Thanks
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2025 Brian Bischof. All Rights Reserved.