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


      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]



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