1 of 1 people found this helpful
You'll need to use the table calculation WINDOW_MEDIAN here.
Your attempt using if [Opportunity]>MEDIAN([Opportunity] is working out the median of each individual opportunity in isolation so that will always return FALSE
Use if [Opportunity] > WINDOW_MEDIAN([Opportunity])
I take it the field Opportunity is already aggregated? If not, what aggregation are you using in the view? You may need to change the formula to
if sum([Opportunity]) > WINDOW_MEDIAN(sum([Opportunity]))
Thanks Robin! it worked