5 Replies Latest reply on Feb 7, 2020 11:14 AM by Tableau_Newbie

    The formula must be an aggregate calculation or refer only to this field

    Tableau_Newbie

      I need help with the syntax of a formula. This is what I want to accomplish.

       

      IF [Event Type] = "Sales Meeting" OR [Event Type] = "Team Tuesday" THEN ([Attendance %]) =  [60% - Attendance % Parameter]

          ELSEIF  [Event Type] = "Company Event" OR [Event Type] = "Team Building" THEN ([Attendance %]) =  [70% - Attendance % Parameter]

          ELSEIF [Event Type] = "Community Event" THEN ([Attendance %]) =  [50% - Attendance % Parameter]

      END

       

      How can I make this work? Also, do you know of any good resources to learn more about complex formulas in tableau?