Need currency in table to be four decimal

SELECTED ANSWER

replied on April 30, 2020 • Show version history

Hi Connie

The currency field can only be 2 decimal. You would need to use a number field instead, where you can set the number of decimal places you want to use.

As for as the $, I’d suggest you just add it the Field label, such as Amount ($).

if you must have the $ display left of your field as the Currency field does, you have to use JS to prepend it Here is a post for that

https://answers.laserfiche.com/questions/96717/How-to-use-javascript-to-format-Currency-Fields#138675

2 0

replied on May 1, 2020

Okay, I think I know what might work then. I'll create a hidden field that will actually hold the 4 digit number. The total field (which is outside the table) can be configured to actually add up the hidden number field instead of the currency field. Thanks, Steve!

0 0

Question

Question

Need currency in table to be four decimal

Answer

Replies

Sign in to reply to this post.