# Formula Field Showing Incorrect Value

**URL:** <https://community.noloco.io/t/formula-field-showing-incorrect-value/840>\
**Category:** Bugs\
**Created:** [June 14, 2024, 3:07pm UTC](https://community.noloco.io/t/formula-field-showing-incorrect-value/840 "2024-06-14T15:07:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [June 14, 2024, 3:07pm UTC](https://community.noloco.io/t/formula-field-showing-incorrect-value/840/1 "2024-06-14T15:07:51Z")

</div>

Hi there, not sure if its a bug or a setting I’ve missed but I have a formula field that seems to be rounding down when its not set to.

If you see the below, Noloco totals £627.76 but a manual calculator totals it as £627.78. Exporting to Excel also reports it incorrectly which I think is down to some values being reported as £16.42 but underneath its £16.416

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/1X/abcc8cf87d5c78e22cccdd7f510374fd40193f69.png)

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/1X/860db2ac52117cc8ed58f1670b521c52755f0f20.png)

Excel showing this

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/1X/0718b128a59f4c1b69a9facfb3779a413812aa30.png)

---

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [June 17, 2024, 12:41pm UTC](https://community.noloco.io/t/formula-field-showing-incorrect-value/840/2 "2024-06-17T12:41:34Z")

</div>

Fixed this by using ROUND(FIELD1\*FIELD2/100,2)