I am trying to make a calculated field based on whether or not there is data in other fields, but I am having problems. I tried using a Case calculation like this:
Case ( IsEmpty ( Phone1 ) ; Phone_Direct1 ; IsEmpty ( Phone1 ) and ( Phone_Direct1 ) ; Phone_Cell1 ; IsEmpty ( Phone1 ) and IsEmpty ( Phone_Direct1 ) and IsEmpty ( Phone_Cell1 ) ; Phone_Home1 ; Phone1 )
It only works for the first test, but not after that. Can you tell me what I am doing wrong? Can I not use "and" here?
Any advice is much appreciated!!