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

    If statement to hide  multiselect drop down filter if all


      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.