You are viewing limited content. For full access, please sign in.

Question

Question

Number Data Type - Currency

asked on July 17, 2015

We have Amount as  Number data type. If we enter a value '123.00', we would like it to display in metadata as '123.00', but it displays as '123'. So, we made it a 'Text' data type. The issue with this is that when we sort this column, it is not sorting based on currency value, it is sorting based on number position. Any suggestions to solve this please? Thanks

 

Priya

0 0

Answer

APPROVED ANSWER
replied on July 17, 2015

See this page regarding field display formats. You can set it back to a number field and have it displayed using the currency format.

0 0

Replies

replied on July 20, 2015

Thanks. 

 

Priya

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.