Is there a way to use the coalesce calculation with more than 2 fields?

SeanNagy1

I have 8 fields that can possibly be filled with data. I want to grab data from the last field that has data and the coalesce function seems to be the best way to do that but it only works with 2 fields. Is there anyway to do that calculation with more than 2 fields?

fklotz

You can nest the coalesce functions, ensuring that your brackets are all closed and the values are listed in reverse order so that they are checked for values in the order you stated in the question.

 

coalesce(${TestArea8}, coalesce(${TestArea7}, coalesce(${TestArea6}, coalesce(${TestArea5}, coalesce(${TestArea4}, coalesce(${TestArea3}, coalesce(${TestArea2},${TestArea1})))))))