Re: Need help calculating Median between 3 values into a label
hi @JonRetro welcome to the community.
you have some work to do to get to the median:
Consider 3 labels txtM1, txtM2 and txtM3 with values 5, 3, 7
The average and median will be the same
Average, "Average: " & Average(txtM1.Text, txtM2.Text, txtM3.Text)
The Median is as follows, "Median" " &
With(
{
_set: [txtM1.Text,txtM2.Text,txtM3.Text] //add the number to a table or collection
},
With(
{
_n: CountRows(_set), //get the number of elements, you can hardcode it to three if thats what you will use all the time
_s: Sort(_set,Value(Value),Ascending) //sort the numbers in ascending order
},
If(
Mod(_n,2) = 0, // choose the calculation based on teh number of elements, yours can be reduced to include Index(_s,(_n+1)/2).Value only as you have an uneven number
(Index(_s,(_n/2)).Value + Index(_s,((_n + 2) / 2)).Value) / 2 ,
Index(_s,(_n+1)/2).Value
)
)
)
changing the values to show the effect
Result
Hope it helps,
R
