Total column not using formatted values

Hi RGallagher320 ，

 You can also format the measure and the new column to Decimal number and 2 decimal numbers. When you format the column and measure, it will just change the displayed content does not change the true value of the underlying data, and the formula uses the underlying data

In your case, when you change column B and column D to Decimal number and 2 decimal numbers , the underlying value for them could be  such as 0.00123 and 0.00000001233113, and you limit them to 2 decimal numbers , so it will show like 0.00. 

Underlying data：

Result：

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai