<div>
There isn't a built-in function however you can use formulas to calculate it yourself. &nbsp;There is a sample crystal report that contains the formulas to do this: <a href="http://support.businessobjects.com/communityCS/FilesAndUpdates/median.zip.asp" rel="ugc">http://support.businessobjects.com/communityCS/FilesAndUpdates/median.zip.asp</a><br />
<br />
frodoman
</div>


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 [http://support.businessobjects.com/communityCS/FilesAndUpdates/median.zip.asp]

frodoman

<div>
Thanks frodoman.<br />
<br />
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.<br />
<br />
But this does get me going in the right direction. <br />
<br />
You wouldn't happen to know of any other resources?<br />
<br />
-Eddie<br />

</div>


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


<div>
<div class="content wysiwyg-content">
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. <br />
<br />
Does anybody know if there is a function to calculate the financial median in CR.NET? <br />
<br />
Any help is greatly appreciated.<br />
<br />
-Eddie<br />
<br />

</div>
</div>


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



Creating a financial median function in Crystal Reports.NET

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.