2 Replies Latest reply on Feb 3, 2016 3:35 PM by Kuljit Jagpal

    Looking for suggestions why I get "Internal Expression Error:  Invalid formula for 'avg'" when pulling a data source from Tableau server

    Kuljit Jagpal

      I, first, create a Data Source by connecting to DB using pre-configured DSN.  In the worksheet, I add a calculated field on one of the columns - e..g avg(Salary) and it checks out OK.  I then publish the data source to Tableau server.

      I close out of Tableau Desktop and then launch it again.  This time I connect to Tableau Server and open up the Data Source I created.  When I go to access the calc field it immediately throws the error "Internal Expression Error:  Invalid formula for 'avg'"

      I'm not sure why this is happening and how to resolve it.  Any ideas/suggestions appreciated.  Thanks.