# How do I round temperature to whole number (WeatherAPI)?

**URL:** <https://forum.adalo.com/t/how-do-i-round-temperature-to-whole-number-weatherapi/24866>\
**Category:** External Collections, Custom Actions & Collections\
**Created:** [March 21, 2022, 4:18am UTC](https://forum.adalo.com/t/how-do-i-round-temperature-to-whole-number-weatherapi/24866 "2022-03-21T04:18:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MikesClub](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mikesclub/32/12754_2.png) [@MikesClub](https://forum.adalo.com/u/MikesClub)\
**Post date:** [March 21, 2022, 4:18am UTC](https://forum.adalo.com/t/how-do-i-round-temperature-to-whole-number-weatherapi/24866/1 "2022-03-21T04:18:07Z")

</div>

I have a weather forecast screen, using the [WeatherAPI.com](http://WeatherAPI.com), following @Victor’s great Youtube tutorial. It works great, but I have one problem. The temperature displays with decimals:

 ![IMG_6899](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/3/a/3a56c7fbce054a50ac85eb24dbe923609ceffee1.jpeg)

That’s just too detailed for a simple weather forecast! Is it possible to round these to whole numbers?

The fact that this data is pulled from an external collection might complicate things.

I’d appreciate anyone’s help.

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [March 21, 2022, 5:16am UTC](https://forum.adalo.com/t/how-do-i-round-temperature-to-whole-number-weatherapi/24866/2 "2022-03-21T05:16:39Z")

</div>

Hi Michael,

You can add a custom formula and add the Round function and add the Result from external collection.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/e/4/e4d6e850b3904d2fbf5a4411d14c350cdf1280b0.png)

( You can found the ROUND Function when you click magic text in the custom formula FUNCTIONS section )

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/c/8/c8ad141dafa131e0c76494f5d8d3a3669cb2f534.png)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/8/2/824d402171cdaf4cf3189c6fd2a18001cb8a659f.png)

The result ( the city is Sri Lanka ) :

( In here I have added the max with decimal too for better understatement if this works )

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/6/6/66d43adff06d5ab5e453edebaacd41975b8a166c.png)

Thank you

---

<div class="post-metadata">

**Author:** ![MikesClub](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mikesclub/32/12754_2.png) [@MikesClub](https://forum.adalo.com/u/MikesClub)\
**Post date:** [March 22, 2022, 3:45am UTC](https://forum.adalo.com/t/how-do-i-round-temperature-to-whole-number-weatherapi/24866/3 "2022-03-22T03:45:43Z")

</div>

Perfect (and very easy)!

Side benefit: Now I know how to use custom formulas!