Troubleshooting Formula Issues in Data Preview Output

Hey there, Im having trouble trying to run a formula. I've checked that all rows have data for that specific field, but it's showing up empty on the formula preview (1st pic). When I run a test formula to see if it'll output something, it does, even though the account names didnt pop up on the formula preview (2nd pic). 3rd pic is the actual formula im trying to run