2 Replies Latest reply on Feb 6, 2019 1:15 PM by Nick Parsons

    LOD help

    ChicagoTableauUser

      I'm getting the error "Expected closing parenthesis or comma while parsing argument list for MAX" with the below LOD formula.

       

      Any idea what I need to do?

       

      { FIXED [Update Period]]:

      MAX([Met with Teacher]="Within last 6 months" or [Met with Head Teacher]="Within last 6 months" THEN 1

      ELSE 0)

      END}

        • 1. Re: LOD help
          Jim Dehner

          hi

          you aggregated the first argument but not the second

           

           

          { FIXED [Update Period]]:

          MAX([Met with Teacher]="Within last 6 months" or max([Met with Head Teacher])="Within last 6 months" THEN 1

          ELSE 0)

          END}

           

          Jim

          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.

          1 of 1 people found this helpful
          • 2. Re: LOD help
            Nick Parsons

            You're missing the "if", there's an extra "]" and the closing parens should be after the end.

             

            { FIXED [Update Period]:

            MAX(

            if [Met with Teacher]="Within last 6 months" or [Met with Head Teacher]="Within last 6 months"

                 THEN 1

                 ELSE 0

            END)}