Re: Formula to return correct subtotals

1. Old Field with old data
2. New Field with new data

I want to return to be, if data exists in the old field, show this data.  However, if data exists in the new field, show that data. 
But the old field is no longer visible, so if data is in both the old and the new, the new field does not update with the new data.  
The only time the new data is displayed is when I change the field in the formula.

I tried to combine the two fields in the table where the totals come from the create the relationship across to the table I want to display the answer.  The results are still the same.

------------------------------
Jessica Matenga
------------------------------