Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
oxiofrt
Partner - Creator
Partner - Creator

How to highlight the nearest value to median ?

Hi,
I have created a table in which is calculated a median. I would like to highlight only one line : the one where the value is the nearest to the calculated median.

A way to do it is to calculate the difference between the value on each line, transform it to unsigned value and then retain the min of those values.

... But I just can't get it ? Can you help ?

You will find an application herejoined.

Thanks a lot !

1 Reply
Not applicable

Could you check this app ? I did it.