3 Replies Latest reply on Jul 24, 2018 7:13 PM by Ankit Bansal

    Nulls in Formulas

    Elie Rahi

      I'm not really understanding how Tableau deal with Nulls and I presume its different to Excel.

       

      I've attached a workbook and im trying to sum up two measures however the second measure has nulls in it. I want to treat the nulls here as 0's (as it would in Excel). However when I do a calc to sum up the two measures it ignore all the rows with nulls.

       

      I've proposed two formulas "Total1" and "Total2" to give you an idea what I need.