4 Replies Latest reply on Apr 27, 2018 4:14 PM by Shinichiro Murakami

    Excluding NULL values in calculation

    vlastimil bartoska

      Hello all I'm trying to calculate eviction rate but the 'Eviction' column contains lots of NULL values. In the calculation 'eviction rate' I would like to have those rows with no values excluded otherwise the results are not correct. I cannot filter out the rows either before I upload the file to Tableau as I need them for another calculation. Hope it makes sense..

       

      Thank you

       

      Tableau Public