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.