Computes the median value of the specified numeric field or array. These are the median values in a numerical sequence (or the average of the two middle values in a straight sequence). The median is the value where there are the same number of lower values as there are higher ones.
It is also possible to specify a condition which records to include.

Median( fld )
Median( fld, condFld )
Median( fld, condFld, cond )

A fractional number.

//returns 4.5 because (3+6) / 2 = 4.5
median([2,6,3,9]) 

//returns the median value of the array
median([2,5,3,2,9,6,4,3,2,5,7,8,5,1,3,6,4])	//returns 4 (lesser higher as lower number)

//returns the median value of the database field
median({Sales.Sales_Amount})

//returns the median Sales_Amount grouped by Vendors
median({Sales.Sales_Amount, Vendors.Vendor})

//a formula that depends on the median value of Sales_Amount
numberVar middle = median({Sales.Sales_Amount});
if {Sales.Sales_Amount} > middle then
	red
else
	black

• If the values in fld should be grouped, a group based on condFld is needed. If the group does not exist in the report, you can add it using i-net Designer or using API method: Engine.addGroup.

• Summary conditions