Median number in crystal formulas
Median number in crystal formulas
(OP)
I have 3 numeric fields and I need to find the median of the 3 fields. What is the formula to do this?
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Come Join Us!Are you a
Computer / IT professional? Join TekTips Forums!
*TekTips's functionality depends on members receiving email. By joining you are opting in to receive email. Posting GuidelinesJobs 

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love TekTips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: Median number in crystal formulas
RE: Median number in crystal formulas
The 'mean' would be the average of the three values. The 'median' is the middle value'.
Andy
RE: Median number in crystal formulas
RE: Median number in crystal formulas
numbervar array x := [{table.field1},{table.field2},{table.field3}];
numbervar med:=0;
if
(
(
x[1]>=x[2] and
x[1]<=x[3]
) or
(
x[1]<=x[2] and
x[1]>=x[3]
)
) then
med := x[1] else
if
(
(
x[2]>=x[1] and
x[2]<=x[3]
) or
(
x[2]<=x[1] and
x[2]>=x[3]
)
) then
med := x[2] else
if
(
(
x[3]>=x[1] and
x[3]<=x[2]
) or
(
x[3]<=x[1] and
x[3]>=x[2]
)
) then
med := x[3];
med
LB
RE: Median number in crystal formulas
Good solution.