1 Reply Latest reply on Nov 21, 2016 9:22 AM by Dan Huff

    Error while communicating with Datasource

    Hema n

      Hi,

       

      I am getting an error "Error while communicating with Datasource" and in Show Details I am getting as Cannot mix aggregate and Scalar Expressions.

      I am using a calculation say ceiling(sum(sales)/date difference between two dates(based on parameter selection)).

      When this is in local extract, it is working fine without errors. But when I publish the data source then I am getting the error.

       

      Please help me on this