Thanks Kamal !!! The given formula is working absolutely fine however still not solving the purpose.
Its giving the count of employee, who are above or below the median but calculating the median of entire population. For example: Data has all job levels like: Executive, Senior Executive till higher leadership. If we compare the CTC with higher leadership with junior management then this will not the right way of analysis.
Can it be possible that the median / average automatically changed when we draw a graph at Job level?? I believe this is due to "Median(Total CTC)".
I tried "count(if([CTC (USD)] > Median([CTC (USD)])]),[Employee Name]))" but expression error. Please help