3 Replies Latest reply on Sep 27, 2018 2:51 PM by Hari Ankem

    Sum integers in field mixed with strings

    Bridget Morton

      Hi, all,

       

      I'm working to sum data coming from an Excel file which has both strings and integers in the same column. Coming from Excel, I'd be able to use a formula like this:

       

      sum(if(isnumber(MEASURE),MEASURE,0))

       

      Is there a (simple) way to recreate this in a calculated field in Tableau?

       

      Thanks!