How do I filter out text in a calculation
I have a field named "Department", which in turn are broken out into categories, which is another field named, "category". Within a specific category, which is named "Shell", I need to remove a department name, which is labeled "Floor Openings", which is part of that Shell category. What's the best way to do this? Below is what I currently have for the field name and calculation. Thanks.
Field Name: total_gross_shell_noflooropenings Calculation: Sum ( sto_STOSPC__shell::Area_Calculated )