9 Replies Latest reply on Jan 7, 2019 8:56 AM by Jonathan Drummey

    Case or If/Then statement not returning Total

    Joe Cooper

      Hi All,

       

      I am coming across an issue that I can't seem to figure out. It seems that I cannot get Total to show when 2 fields are combined using plus(+) with either using CASE or IF/Then statement.

      Using Tableau 10.5 and data is extracted from a SQL Server Stored Procedure.

       

      Below is the image of the issue. I am attaching sample data as well.

       

      Error Total.png

       

      Any help or input on how to fix this?