3 Replies Latest reply on Oct 24, 2018 5:44 AM by arvin.ramchurn

    If statement to hide  multiselect drop down filter if all

    arvin.ramchurn

      we have dynamic text to display what a user has selected - out of 10 filters.

       

      We dont want to display 'All'  value if all is selected from some drop downs just those that have anything other than All.

       

      I found this

      SUM(IF [Status]="Open" THEN [Field 1] ELSE 0 END)/SUM(IF [Status]="Open" THEN [Field 2] ELSE 0 END)

       

      But its not working for us.