Split Value of Row when there is a non-null value in both columns

[julief]

I want to combine the columns Adjusted Area Field 1 and Adjusted Area Field 2 into 1 column. I have created a calculated field so that hen the data has a non null value in Adjusted Area Field 1 and Adjusted Area Field 2, the value displays .5. When that happens, I want the count to count .5 for each area when the columns are combined. 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.  How can I do this?

[sam8]

Just to be clear, are you looking to add 0.5 if either field is not null? So the results would look something like this?

Field 1	Field 2	Value
one	null	0.5
null	two	0.5
three	four	1

If so, you could write a calculated field with some cases!

CASE
WHEN ((NOT (field1 is null)) AND (NOT( field2 is null))) THEN 1
WHEN field1 is null OR field2 is null THEN 0.5
ELSE 0
END