FM Bash! Posted May 25, 2005 Posted May 25, 2005 I have a field that will return a case, but I do not want the calculation done until information has been selected in another field that has a value list. Example: My charging field will return: Case(ads total inches <= 25, "25.00", ads total inches < 72, "40.00") I would like this to happen only if a selection was made in another field that contains a value list. Otherwise this charging field would remain empty. What do I need to build? Thank you!
-Queue- Posted May 25, 2005 Posted May 25, 2005 Case( not IsEmpty(somefield), Case( ads total inches <= 25, "25.00", ads total inches < 72, "40.00" ) )
FM Bash! Posted May 26, 2005 Author Posted May 26, 2005 Rock & Roll..... This work great. A path I haven crossed yet made simple! Thank you!!!!
Recommended Posts
This topic is 7469 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