Error in a Custom Formula Column

Error in a Custom Formula Column

I have an error in a custom formula column. I have a VERY simple formula in a custom column. Here is the formula: 
"Column Name"* .15 

All I am tryting to accomplish is to multiply in order to get a % of another column. But it only works on some of the entries like in the image below: 


You can see that for some of the rows are blank and for no apparent reason. I was told when I contacted support about the issue that all I have to do is add a ZERO before the decimal in the formula. So I did that. And it works.... for a while...
But then it stops working, and after a while only about 50% of them have data in them. So then I remove the ZERO in the formula and the data comes back, but only for a limited time. 

So the "adding or subtracting a zero in the formula" is only a temporary fix. I have about 6 fields that I need to update (adding or removing a ZERO) every time I run a report. It is getting rather frustrating. I was curious if you can look into the consistency. Thanks!