# Currency datatype - error with decimal fraction \[Apr 13\]

**URL:** https://community.nocodb.com/t/currency-datatype-error-with-decimal-fraction-apr-13/360
**Category:** Discord-Discussions
**Created:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/currency-datatype-error-with-decimal-fraction-apr-13/360 "2022-11-03T08:56:06Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/currency-datatype-error-with-decimal-fraction-apr-13/360/1 "2022-11-03T08:56:06Z")

</div>

> 🙋‍♂️ **softinio** _asked_

## got a quick question, I have created a table with a currency field. It all works fine except when the decimal part ends with a zero

---

<div class="post-metadata">

### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/currency-datatype-error-with-decimal-fraction-apr-13/360/2 "2022-11-03T08:56:07Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### \<@460833082002374656\> - its a bug. we will look into it

#### Created an issue here

#### [Currency field- validation fails if decimal fractions are used · Issue #1647 · nocodb/nocodb · GitHub](https://github.com/nocodb/nocodb/issues/1647)

#

---

<div class="post-metadata">

### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/currency-datatype-error-with-decimal-fraction-apr-13/360/3 "2022-11-03T08:56:08Z")

</div>

> 🙋‍♂️ **softinio** _replied_

#### \<@857998597474484295\> thank you for creating issue and quick help

#

---

<div class="post-metadata">

### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/currency-datatype-error-with-decimal-fraction-apr-13/360/4 "2022-11-03T08:56:10Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/963321317753495563)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)