Exclude 0 from median calculation

[rekhagrramadas]

I have to exclude 0 from median calculation, my expression looks like below, my annul_new column can come as 0, so I have already made as Null() in the data load editor. but still when its divided by annul_new its coming as 0, which comes in the median calculation

Median(Aggr(Sum({<flag_deal={'-11'},flag_productivity={'TMO_Productivity'}>}(deal_revenue_productivity/1000)/annul_new), median_key))

[rubenmarin · Accepted solution]

Hi, have you tried to keep the zero and exclude in set analysis?:

Median(Aggr(Sum({<flag_deal={'-11'},flag_productivity={'TMO_Productivity'},annul_new={">0<0"}>}(deal_revenue_productivity/1000)/annul_new), median_key))

[rekhagrramadas]

Thanks for your reply, let me try that and get back to you

[rekhagrramadas]

Thank you @rubenmarin that worked!