Median Aggregate Formula - Percentile Workaround

Median Aggregate Formula - Percentile Workaround

Hello,

This is a very specific example, but I'm hoping to find a workaround for calculating Median. See below request:

I've tried the Percentile workaround for Median in Zoho, but for some reason my aggregate formula is not calculating the Median. For instance:
  • Aggregate formula used:
  •       Percentile("ODC Dec2015-Apr2016"."GROSS_REVENUE",50)
  •             On the graph, the only number appearing is the highest value vs. the actual media.
Is there something off with my formula? Please advise.

Thank you.