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!