9 Replies Latest reply on Nov 29, 2016 10:36 AM by Sherzodbek Ibragimov

    Resolving Aggregate vs Non Aggregate Errors

    noah Carraher

      Hi - I would really appreciate some advice on how best to resolve the error that occurs when you try to combine aggregated and non aggregated fields in Tableau .

       

      Here is my specific problem--

       

      IF {FIXED [ClinicName]: max([CreateDate])}= [CreateDate] then [percentcontrol2] END

       

      In this case, precentcontrol2 is aggregated , the rest is not. As a result the calculation does not work.

       

      thanks in advance,

      Noah