Median Function In ReportNet

[gazula007]

Hi,

Please let me know How to get 'Median' Function in Reportnet.

Tks

[BIsrik]

I couldn't get what would be the use of median in any reports...

  Well to get the median u need to first sort the values of the field and then count the number of records and apply the median formulae..

for eg:

   if ur database column had these values...

    coln1
     4
     1
     3
     5
     7
  then this shuld be first sorted in the database itself..( bcause u cannot store any values in CRN Server)

   then ur column in the database should look like

   coln1
    1
    3
    4
    5
    7

Then count the total rows by saying count( coln1 for report) and then apply the median formulae...

But plz share with us the use of median in the report...

Srik