topic Re: Table sum roundup in AutoCAD Forum

Table sum roundup

gandi.nbgd — Fri, 15 Apr 2022 13:56:30 GMT

Hello,

I need some help with rounding sum numbers in autocad table. Tried some things like round() and trunc(), but it doesn't work, or I'm doing something wrong.

All this areas are linked to hatch in model, and their field looks like this: (with conversion factor of 0.0001 (cm2-m2))

All I need is simple thing at first, sum at the end to use this two decimal numbers when doing the math, and not the whole 164.366344 for example. So end result needs to be 2420.61 instead of 2420.59.

Thanks in advance!

Re: Table sum roundup

Patchy — Fri, 15 Apr 2022 14:32:28 GMT

It works that way same as excel.

Re: Table sum roundup

JTBWorld — Sun, 17 Apr 2022 14:57:01 GMT

Try something like this:

round(a1*100)/100 +round(a2*100)/100 +round(a3*100)/100

Re: Table sum roundup

gandi.nbgd — Wed, 11 May 2022 14:30:23 GMT

No luck, same wrong number

Re: Table sum roundup

JTBWorld — Wed, 11 May 2022 14:32:32 GMT

Can you upload a sample DWG?

Re: Table sum roundup

gandi.nbgd — Wed, 11 May 2022 14:52:06 GMT

Here is one example of this problem

Betreff: Table sum roundup

cadffm — Wed, 11 May 2022 15:15:03 GMT

Autocad fields alway calculate with the real values, not with your display values

Re: Table sum roundup

JTBWorld — Wed, 11 May 2022 15:19:40 GMT

You need to use this:

=round(b1*0.01)/0.01 +round(b2*0.01)/0.01 +round(b3*0.01)/0.01+round(b4*0.01)/0.01

Re: Table sum roundup

gandi.nbgd — Thu, 12 May 2022 07:19:43 GMT

Worked, thank you very much !

Re: Table sum roundup

st19675 — Wed, 17 May 2023 15:08:06 GMT

Hello to everyone,

Thank god finally found the solution to a similar problem I have.

Hope someone can solve my problem:

I have a table with Object Area Fields inside. Also I have a column sum. I would like to roundup numbers like: 82.09 to 82.10, 1.66 to 1.70, 83.03 to 83.00....

Hope someone can help me.

Thanks a lot in advance 🙂

Re: Table sum roundup

JTBWorld — Wed, 17 May 2023 15:29:19 GMT

Round 83.03 to 83.00 or 84.00?

Re: Table sum roundup

st19675 — Wed, 17 May 2023 16:29:08 GMT

Thank you for your fast answer Jimmy,

I need to round up from 0.05 up or round down from 0.04 down, as for example: 73.91 to 73.90, 75.56 to 75.60, 5.25 to 5.30, etc

Thanks a LOT 🙂

Re: Table sum roundup

JTBWorld — Fri, 19 May 2023 13:09:08 GMT

That would be like this: round(A1*10)/10

Re: Table sum roundup

st19675 — Tue, 23 May 2023 10:06:49 GMT

Finally it worked like this:

ROUND(A1/0.05)*0.05

Thank you very much!

Re: Table sum roundup

wquevedoPBBV4 — Tue, 16 Jan 2024 17:01:39 GMT

Thank you so much.