Hi all
Is there a way to calculate mean, median and mode as in Crystal? If so could
you point me to a source, I am not much on programming but willing to give
that a go if I have to.
thanks.In the current release of RS there is not a way to do this - I'm not sure if
RS 2005 will have this capability.
I had to calculate median values for a report that I designed and ended up
having to do the calculations in a stored procedure that my dataset was
using. You stated that you're not to up on programming so I'll tell you the
theory behind what I did and if you want the source I'll be glad to send it
to you.
Basically to get the median value for a dataset what you need to do is total
up the number of rows for the dataset/table and divide by 2. Once you have
that value all you have to do then is go in and retrieve the value that
resides at that row number and that will give you the median value.
hth,
Bill Youngman
Anexinet, Inc.
"darwin" <darwin@.discussions.microsoft.com> wrote in message
news:A6FD67C6-41BE-43A9-B89C-F690EDE564D4@.microsoft.com...
> Hi all
> Is there a way to calculate mean, median and mode as in Crystal? If so
could
> you point me to a source, I am not much on programming but willing to give
> that a go if I have to.
> thanks.
>
No comments:
Post a Comment