ErikP Posted June 12, 2003 Share Posted June 12, 2003 I'm trying to create a calculation field using FM5.5 that will return one of two values based on the value of another field. The art department requests ink samples from the ink lab and assigns the ink a temporary formula name of "TBD1234". Once the ink lab formulates the ink, the formula name is updated and the "TBD" portion is removed. I'm trying to create a calc field like so: If(Formula Field = "TBD"*, "FORMULATE", "COMPLETED") Unfortunately the asterisk character doesn't return anything. Is this possible? Link to comment Share on other sites More sharing options...
danjacoby Posted June 12, 2003 Share Posted June 12, 2003 Use the PatternCount function to determine if "TBD" is a part of that field. Link to comment Share on other sites More sharing options...
Lee Smith Posted June 12, 2003 Share Posted June 12, 2003 Hi Dan and Erik, I didn't have any luck structuring the If Statement, but this Case works. Case(PatternCount(Formula Field, "TBA"), "FORMULATE", "COMPLETED") HTH Lee Link to comment Share on other sites More sharing options...
ErikP Posted June 13, 2003 Author Share Posted June 13, 2003 Lee, Case calc worked great! Many thanks. Erik Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7623 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now