Table problems

[stevenpalma]

When using tables to calculate square footages, you can put the subtotals as fields connected to a polyline.

You can then have them automatically total, thus removing the need to manually key in anything.

Well here is a rather annoying little problem, hopefully someone out here has run into this and has a workaround?

When inserting the value as a field from a polyline, if you choose to change the precision of the number displayed to a whole number it will automatically round that number either up or down based on the decimal amount. As one would assume if the amount is less than .5 it rounds DOWN and more than .5 it rounds UP.

Well here is the problem, you could have two numbers that are both less than .5 and so they would be rounded down, HOWEVER, the subtotal of those numbers could force he decimal portion OVER .5 thus rounding UP the subtotal.

When this happens it looks like this. Which it clearly looks like a math error.

But behind the scenes those numbers are actually this

Anyone ever run across this?

Help!

[sophia_lee]

Hi @stevenpalma,

Please follow the suggestions below; 

1. Right click on the table and go to 'Data Format'. 
2. Click on 'Decimal Number' > click 'None' > OK. 
3. Then you will see it's not rounding up anymore.

              

         

Here is the additional article for your reference. 

• Rounding Values in table cells does not work in AutoCAD.

Hope this is helpful. Please 'Accept as Solution' if this answers your question. 

[stevenpalma]

Thanks for the feedback. But if you look at the "resulting table" it still doesn't add up.

[pendean]

Post your actual DWG file with your actual table please so we can all dissect your work and possible issue.
TIA