I have a portal or video equipment that I am filtering by category (eg: Camera, Audio, Lighting, etc) using a drop down menu. In the value list I am using for the filtering, I have added "All". Is there a way to create the calculation to not filter the portal when All is selected?

Create a calc field cFilter defined as "All" & ¶ & YourTable::categoryField.

Define the value list of categories for your drop down list using values from this field.

(If you want All to be the first value in the list use an underscore before the word -- "_All" -- in the calc.)

Try something like =

gCategory = Equipment::Category

or

gCategory = "All"