Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

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.

-Eddie

0
FastEddie___
Asked:
FastEddie___
  • 2
1 Solution
 
frodomanCommented:
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: http://support.businessobjects.com/communityCS/FilesAndUpdates/median.zip.asp

frodoman
0
 
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?

-Eddie
0
 
frodomanCommented:
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.

frodoman
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now