# Number formatting and calculation bug

**URL:** <https://forum.manager.io/t/number-formatting-and-calculation-bug/18154>\
**Category:** Uncategorized\
**Created:** [September 24, 2018, 6:20am UTC](https://forum.manager.io/t/number-formatting-and-calculation-bug/18154 "2018-09-24T06:20:08Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![ntrim](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ntrim/32/18838_2.png) [@ntrim](https://forum.manager.io/u/ntrim)\
**Post date:** [September 24, 2018, 6:20am UTC](https://forum.manager.io/t/number-formatting-and-calculation-bug/18154/1 "2018-09-24T06:20:08Z")

</div>

Calculation in line amounts and Totals ignores decimal character.

 ![Clipboard01](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/9/294f2219b15c5208b299dd0716644128f0b6948a.jpeg)

After saving or updating the record the calculation is correct.

Version 18.9.86

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [September 24, 2018, 11:57am UTC](https://forum.manager.io/t/number-formatting-and-calculation-bug/18154/2 "2018-09-24T11:57:33Z")

</div>

What is your number format set under `Preferences` tab? I will try to reproduce it.

---

<div class="post-metadata">

**Author:** ![ntrim](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ntrim/32/18838_2.png) [@ntrim](https://forum.manager.io/u/ntrim)\
**Post date:** [September 24, 2018, 12:12pm UTC](https://forum.manager.io/t/number-formatting-and-calculation-bug/18154/3 "2018-09-24T12:12:34Z")

</div>

123.456.789,00

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [September 24, 2018, 12:35pm UTC](https://forum.manager.io/t/number-formatting-and-calculation-bug/18154/4 "2018-09-24T12:35:45Z")

</div>

I can reproduce this error. But the bug goes further. When returning to an Edit screen, values for `Unit price` have changed. The following sequence shows initial input, resulting View screen, and Edit screen upon returning to the transaction:

![34%20AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/1/c/1ccb75e67b9d38026ba11f37b146d6d387d92864.png)  
 ![15%20AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/6/06610558af8be943679efc03acb6a63fa87c68f1.png)  
 ![52%20AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/c/fc94bf02bf990f14b833e5b67d8a68cfad14b884.png)

This also happens on more than just payments. It also happens on sales invoices and, probably, others.

---

<div class="post-metadata">

**Author:** ![NIKKON](https://avatars.discourse-cdn.com/v4/letter/n/c57346/32.png) [@NIKKON](https://forum.manager.io/u/NIKKON)\
**Post date:** [September 24, 2018, 3:49pm UTC](https://forum.manager.io/t/number-formatting-and-calculation-bug/18154/5 "2018-09-24T15:49:25Z")

</div>

When a dot is used the problem occurs. When using a comma everything is OK

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/b/bbc31473df677928840a75d3021e0239eae1e499.png)

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [September 24, 2018, 11:19pm UTC](https://forum.manager.io/t/number-formatting-and-calculation-bug/18154/6 "2018-09-24T23:19:45Z")

</div>

Should be fixed in the latest version (18.9.91)

This also adds built-in calculator across all number fields.

---

<div class="post-metadata">

**Author:** ![ntrim](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ntrim/32/18838_2.png) [@ntrim](https://forum.manager.io/u/ntrim)\
**Post date:** [September 25, 2018, 4:55am UTC](https://forum.manager.io/t/number-formatting-and-calculation-bug/18154/7 "2018-09-25T04:55:23Z")

</div>

Back to normal.  
Thanks

---

<div class="post-metadata">

**Author:** ![pandhm](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@pandhm](https://forum.manager.io/u/pandhm)\
**Post date:** [October 2, 2018, 9:52am UTC](https://forum.manager.io/t/number-formatting-and-calculation-bug/18154/8 "2018-10-02T09:52:10Z")

</div>

The problem remain in Payslips

![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/a/cafd3c54534f98cfd29e482005a6d84109bb1085.png)

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [October 2, 2018, 5:58pm UTC](https://forum.manager.io/t/number-formatting-and-calculation-bug/18154/9 "2018-10-02T17:58:15Z")

</div>

@pandhm can’t reproduce this issue. What’s your number format under `Preferences` tab?

---

<div class="post-metadata">

**Author:** ![pandhm](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@pandhm](https://forum.manager.io/u/pandhm)\
**Post date:** [October 3, 2018, 6:38am UTC](https://forum.manager.io/t/number-formatting-and-calculation-bug/18154/10 "2018-10-03T06:38:33Z")

</div>

@lubos  
123.456.789,00  
in the edit screen is as below

![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/4/b473d50179529d2ea7b0ff3a172c2e7ea0aebc5e.png)

while in the view is right. Version 18.10.18

![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/2/22fc521f6c8ccec00837599cd4ecd7db21da74b5.png)

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 3:08pm UTC](https://forum.manager.io/t/number-formatting-and-calculation-bug/18154/11 "2023-01-18T15:08:53Z")

</div>

Closed on January 18, 2023, 3:08pm UTC


