Creating a financial median function in Crystal Reports.NET

The median function built into Crystal Reports.NET uses a statistal median where the lessor of the middle values is discarded. I need to use a finanical median in my report. The financial median takes the two middle numbers and divides by 2 to get the median.

Does anybody know if there is a function to calculate the financial median in CR.NET?

Any help is greatly appreciated.


Who is Participating?
frodomanConnect With a Mentor Commented:
Eddie -

I wouldn't even worry about the .mdb database.  Just open the .rpt file and look at the formulas that are in there - that's really all you need.

There isn't a built-in function however you can use formulas to calculate it yourself.  There is a sample crystal report that contains the formulas to do this:

FastEddie___Author Commented:
Thanks frodoman.

I downloaded the zip but I couldn't get the .MDB database file to open. It is either an old version that can not be converted or corrupt and the readme.txt file has a lot of strange charactors in it.

But this does get me going in the right direction.

You wouldn't happen to know of any other resources?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.