Changing data populated by SQL Query

So I have a column that is populated by a field in an Oracle database. It returns a Boolean of either 0 or 1. I would like for that column to read either No or Yes respectively. I have tried =if(G1=0,"No", "Yes") but i get an error about a circular formula. I then tried adding a new column with the same formula but all I got was a bunch of zeros.

Any help would be appreciated.