Thanks @shijithpulikkal . I have an additional caveat I am now finding and I am hoping you can help.
When the data has a non null value in Adjusted Area Field 1 and Adjusted Area Field 2, when I coalesce them, I want the count to count .5 for each area. So for instance, with Deliver in Adjusted Area Field 1 and Build in Adjusted Area Field 2, I want to add .5 to the Deliver total AND .5 to the Build total when I combine everything. Do you know how to do this?
