2 followers Follow

Currency cell to hold their second decimal place if 0.

When creating a currency field, with 2 decimal places, I expect it keep the 0 if the value after the decimal point is a multiple of 10. 

For example, 123.40 is displayed as 123.4. 

When I try save 123.40, it defaults to 123.4. 

This is a currency field and not a numerical field and therefore should keep the zeroes.

For a system working significantly with financial data, this should be compulsory. 


Darren Answered

Please sign in to leave a comment.

1 comment


Hi Chris - for each column in any table view (including Work Plan) you have display formatting options. One of the options is to show trailing zeros (image below) which should give you what you are looking for without waiting for us to make any changes.

You make a valid point about the financial data systems, however we also see people looking to display rounded financial data. It seems there are different expectations depending on what item you're on and even what kind/size of projects you do and the types of costs & units you work with. Just this week we had a customer requesting to round to 2 decimal places in grids, but show 9 decimal places (which they defined on their currency field) on mouse hover. 

We'll add it to our Change Requests list - but there is an alternative way to achieve what you need.

David Goulden 0 votes
Comment actions Permalink