This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Try using a formula tool and implementing "if (([Age-years]==Null()) or (IsEmpty([Age-years])) then Null() else [Age-years] endif" into your [Age-years] field. This should make sure that there is only either a number or Null() values. If there is possibly a blank row in that field then the formula should turn it into a null() for you. Hopefully that works!
I think a work around to approach this problem is to use a formula tool and set null() values to 0. Then create an record id. After the record id use a summarize tool and use medianNo0 to get the median excluding 0. Append the new age median field.