May 25, 200520 yr 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!
May 25, 200520 yr Case( not IsEmpty(somefield), Case( ads total inches <= 25, "25.00", ads total inches < 72, "40.00" ) )
May 26, 200520 yr Author Rock & Roll..... This work great. A path I haven crossed yet made simple! Thank you!!!!
Create an account or sign in to comment