Display result without sum, count, or anything else

I created a new column and used the lookupvalue function to find the desired result.  When I look at the data it is populating the column correctly for each row but when I try and place the value in ...