3 Replies Latest reply on Jun 28, 2017 2:51 PM by Simone Betito

    How to remove null from totals formula?

    Simone Betito

      Hi everyone,

       

      I created a formula that's a sum of rows. However, I get Nulls in this totals column even if some of my rows have numbers in it.

       

      For example,

      Tableau formula.PNG

       

      I'd like to see 17 show up in my "Sum of Totals" column here but instead I'm seeing "Null" in the totals. The formula only works when there's numbers across the row w/o any nulls (as seen in the totals column below): 

      Tableau issue.PNG

       

      How can I get a total to show up even if I have some null fields in the row?

       

      Hopefully this made sense. I'm unable to share my workbook due to confidential information.

      Thanks!