# How to set number of decimal places

**URL:** <https://forum.cloverdx.com/t/how-to-set-number-of-decimal-places/1750>\
**Category:** CloverDX Platform\
**Created:** [May 6, 2016, 12:00am UTC](https://forum.cloverdx.com/t/how-to-set-number-of-decimal-places/1750 "2016-05-06T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![daveinhants](https://avatars.discourse-cdn.com/v4/letter/d/db5fbb/32.png) [@daveinhants](https://forum.cloverdx.com/u/daveinhants)\
**Post date:** [May 6, 2016, 12:00am UTC](https://forum.cloverdx.com/t/how-to-set-number-of-decimal-places/1750/1 "2016-05-06T00:00:00Z")

</div>

Apologies that this is such a stupid question!

Please could someone advise what function to use to set the number of decimal places of a number(long), using the Transform Editor. So I just want to set 1.9993335 to be 1.99

Thanks!

Dave

---

<div class="post-metadata">

**Author:** ![PedroVazquezRosario](https://avatars.discourse-cdn.com/v4/letter/p/ed8c4c/32.png) [@PedroVazquezRosario](https://forum.cloverdx.com/u/PedroVazquezRosario)\
**Post date:** [May 9, 2016, 3:15pm UTC](https://forum.cloverdx.com/t/how-to-set-number-of-decimal-places/1750/2 "2016-05-09T15:15:11Z")

</div>

Hi,

I would recommend two options depending if you want to round the decimal value or not:

- You can change the metadata type from number to decimal (will not round the value), also make sure you specify the precision in property _Scale_
- Use a Reformat component and in the CTL code use function round (you can find more information on how round [here](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/mathematical-functions-ctl2.html))