1 Reply Latest reply on Apr 24, 2018 5:11 AM by Jim Dehner

    Problem with aggregate arguments

    Manuel Cuesta



      I´ve a calculated field, this calculated field has done with lookup function. Now, I want to include in a parameter but tableau show this error "Cannot mix aggregate and non-aggregate arguments with this function".


      I tried a lot of form of the calculated field but i don´t solve this problem.


        • 1. Re: Problem with aggregate arguments
          Jim Dehner

          Good morning

          the issue is that      _OBJ % is aggregated - in your Conditional statement you need to aggregate [Year] - you can use min(), max(), attr()


          whichever is appropriate in your analysis



          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.