AnsweredAssumed Answered

How do I filter out text in a calculation

Question asked by lbellino on Apr 27, 2011
Latest reply on Apr 29, 2011 by philmodjunk

Title

How do I filter out text in a calculation

Post

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 )

FMP_Example.PNG

Outcomes