# Round out numbers on DC attributes and report

**URL:** <https://forums.sketchup.com/t/round-out-numbers-on-dc-attributes-and-report/252710>\
**Category:** Dynamic Components\
**Tags:** report, attribute\
**Created:** [December 21, 2023, 11:59am UTC](https://forums.sketchup.com/t/round-out-numbers-on-dc-attributes-and-report/252710 "2023-12-21T11:59:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Syksy](https://sea2.discourse-cdn.com/sketchup/user_avatar/forums.sketchup.com/syksy/32/194923_2.png) [@Syksy](https://forums.sketchup.com/u/Syksy)\
**Post date:** [December 21, 2023, 11:59am UTC](https://forums.sketchup.com/t/round-out-numbers-on-dc-attributes-and-report/252710/1 "2023-12-21T11:59:48Z")

</div>

Hello everyone!

Im here with an special request of help, i need to round out this numbers like this:

![Senza titolo](https://global.discourse-cdn.com/sketchup/original/3X/a/7/a70f52f3f7fb563af6cc65ab7c9122105bfff5b4.png)

As you can see, are two different types of rounding numbers, on the first one i should round it down from for example : 233,554 to 233. Above all because this value comes out on the report.  
(i know i can do this in excel but i am being requested to get the report as clean as possible)

On the other hand, the 1 you see in “spessore” comes from “tube” that is 1.0 (text), and i need it to be 1.0 , because in toher values will be 1.2…1.4…ecc

thank you!

---

<div class="post-metadata">

**Author:** ![glennmstanton](https://sea2.discourse-cdn.com/sketchup/user_avatar/forums.sketchup.com/glennmstanton/32/103192_2.png) [@glennmstanton](https://forums.sketchup.com/u/glennmstanton)\
**Post date:** [December 21, 2023, 2:46pm UTC](https://forums.sketchup.com/t/round-out-numbers-on-dc-attributes-and-report/252710/2 "2023-12-21T14:46:25Z")

</div>

=ROUND(num to round, num past decimal) e.g (ROUND(LenY\*10,0)

in the case of 1 → 1.0 – this looks like an input value, so use decimal number type in the input box.  
 ![image](https://global.discourse-cdn.com/sketchup/original/3X/4/e/4e9866261f0f9916a68450971ab3def014f70f59.png)

for the T 1.0 - you should fix the source to provide the value 1.0 (although by default it seems that numbers which end in .0 (or more zero) display as integer…

[Dynamic Components Math Function Examples | SketchUp Help](https://help.sketchup.com/en/sketchup/dynamic-components-math-function-examples#) [https://help.sketchup.com/en/sketchup/dynamic-components-math-function-examples#](https://help.sketchup.com/en/sketchup/dynamic-components-math-function-examples#)

---

<div class="post-metadata">

**Author:** ![Syksy](https://sea2.discourse-cdn.com/sketchup/user_avatar/forums.sketchup.com/syksy/32/194923_2.png) [@Syksy](https://forums.sketchup.com/u/Syksy)\
**Post date:** [December 22, 2023, 8:20am UTC](https://forums.sketchup.com/t/round-out-numbers-on-dc-attributes-and-report/252710/3 "2023-12-22T08:20:08Z")

</div>

the first one worked perfectly!  
The second one im afraid it wont work as you well said, it wont show values after 0.  
Thank you so much anyway!

---

<div class="post-metadata">

**Author:** ![pcmoor](https://sea2.discourse-cdn.com/sketchup/user_avatar/forums.sketchup.com/pcmoor/32/3427_2.png) [@pcmoor](https://forums.sketchup.com/u/pcmoor)\
**Post date:** [December 22, 2023, 10:23am UTC](https://forums.sketchup.com/t/round-out-numbers-on-dc-attributes-and-report/252710/4 "2023-12-22T10:23:30Z")

</div>

if text, 1.0 as typed should hold, however any formula will try to evaluate numerical text as a number,