# Can't get two decimal point format in subtotal table?

**URL:** <https://forum.inductiveautomation.com/t/cant-get-two-decimal-point-format-in-subtotal-table/26085>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [June 25, 2019, 3:54pm UTC](https://forum.inductiveautomation.com/t/cant-get-two-decimal-point-format-in-subtotal-table/26085 "2019-06-25T15:54:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [June 25, 2019, 3:54pm UTC](https://forum.inductiveautomation.com/t/cant-get-two-decimal-point-format-in-subtotal-table/26085/1 "2019-06-25T15:54:08Z")

</div>

Using Ignition 7.9.1.

I have a table of values, and underneath, it a table that has custom properties that sum up different columns in the main table, and then uses the custom properties in a Cell Update function to display the subtotals. One column in particular is not showing the cents.

Now on first observation I noticed the column was kept in the databse as a INT, but I’ve since changed that to match the other columns, a decimal(11,2) type.

The custom property that calculates it is as follows `try( sum({Root Container.Table_SalesOrders.data}, "leftMargin" ) ,0)` which the cell update is bound to.

The table customizer property has `$#,##0.##` as a the number format. What else could possibly be preventing this from shownig 2 decimals in my subtotal table?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 25, 2019, 4:51pm UTC](https://forum.inductiveautomation.com/t/cant-get-two-decimal-point-format-in-subtotal-table/26085/2 "2019-06-25T16:51:47Z")

</div>

The hash marks in the number format mean “don’t show leading/trailing zeros”. Change your format to **$#,##0.00**.