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,