I have 3 objects in a hierarchy, customer1, customer2 and customer3. I need to write an IF statement that states -
If customer1 is null or = '?' then customer2. If the output of that statement (i.e. customer2) is null or = '?' then customer3.
So customer1 is the priority if populated, then customer2, then lastly customer3 if neither 1 or 2 are populated.