Seems like the calculation was not showing properly in the view. Erase the calculation part in the field and again do the calculation. You will get the correct result.
Please mark the answer as helpful if your question is resolved.
Thanks for the quick reply. I have never had the replace reference require rewriting the formula completely from scratch but that definitely worked.