Median number in crystal formulas 2

[jchewsmith]

I have 3 numeric fields and I need to find the median of the 3 fields. What is the formula to do this?

 

[kray4660]

The median is just an average, thus since you have three fields, you can create formula similar to this ({field1}+{field2}+field3})/3

 

[AndyMc]

kray,
The 'mean' would be the average of the three values. The 'median' is the middle value'.
-Andy

 

[jchewsmith]

Yes I am looking for the middle number of the 3 fields.

 

[lbass]

Create a formula like this:

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

 

[kray4660]

Go figure after being out of college for over thirty years I would forgot the difference between Median and Mean

Good solution.