1 Reply Latest reply on Jun 13, 2018 9:19 AM by Jim Dehner

    Calculating Median - Null or Zero? Or both?

    Ryan Smith

      I have what I think is a simple question.

       

      I have a dataset with a row with wages. If no wages are available, it's noted as "0" in the cells. I want to calculate a median for the wages. Does Tableau include the zeroes in the calculation for median? I don't think it uses null (or blank) cells in the calculation for median.

       

      If it *does* use zeroes in the calculation of median, then it would be easy for me to just delete the zeroes in the cells and leave them blank.

       

      Thank you.