tallboy755 Posted December 20, 2002 Posted December 20, 2002 Here is the scenario I have a field named "info_Package" and a field named "z_Calc" I need a calculation that will put a number that i can set in the calculation such as "34" in the "z_Calc" field if the "info_Package" contains a "C" So if the field "info_Package" contains "ACL" i need a "36" or a "27" (number that i can set in the calc) in the 'z_Calc" field .... however if "info_Package" contains "AL" need "z_Calc" to have a "0" Here is the calculation i currently have and it doesn't work If(info_Package = "C", "1", "0")
tallboy755 Posted December 20, 2002 Author Posted December 20, 2002 Got it ... Thanks to a little help from live oak here is the code that works If( PatternCount(info_Package,"A"), "32", "0")
Recommended Posts
This topic is 8079 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