Forum Discussion
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
Super Userhi RGallagher320 ,
the decimals that you see is only visual so if you have more values on the number it will calculate accordingly. I suggest you make the use of the round when making the calculating.