Truncating an object's area value in tables

[dpalmerVQ54W]

I have a formatted table (see below). The problem is that neither of my totals at the bottom of the table do not equal the sum of the displayed numbers. I'm guessing that the Sum is using the "current value" rather than what is displayed. The screenshot below shows the formatting I have for the "sq m" cell.

The screenshot below shows the formatting for the "sq ft". This is a formula.

Is there anything I can add to the "sq ft" field expression to so that it looks at the number displayed. Same with the totals. These should be adding up the number displayed, which they currently do not.

Thanks in advance.

[calderg1000]

Regards @dpalmerVQ54W 

Follow the steps that I indicate in the image.

[dpalmerVQ54W]

@calderg1000 sorry I don't understand why you suggest I change the precision "to the proper settings"! The precision displayed in the table cannot be changed as it is fixed by required standards we work to.

Can't something be added to the Field Expression to force it truncate the cell contents (not the displayed value)?

[Sea-Haven]

If it was excel you would have a hidden column with say all the areas at 3 decs precision. Any time you round values and add them they will not necessarily add up to true total. Have seen this in land titles where lots are to mm but displayed to 10mm. Hide a column in a table does not appear to be supported, but this suggestion may work add column on right sidewith true say 3 decs values.

Will try to work out the VL commands this is column width (VLA-SETCOLUMNWIDTH OBJ 5 0.0)