Hi,
When I am getting any query in SmartList, the amounts are showing in 5 decimal places. How to format it to show only 2 decimal places and with accounting number format.
Thanks,
Ran
*This post is locked for comments
Hi,
When I am getting any query in SmartList, the amounts are showing in 5 decimal places. How to format it to show only 2 decimal places and with accounting number format.
Thanks,
Ran
*This post is locked for comments
Ran,
Here is a link to a Microsoft Knowledge Base article on why this happens, and what methods they would suggest for dealing with what is a design decision.
We recommend SmartList Builder and other eOne products to all of our clients, and most of them implement them. If you have SmartList Builder, you can actually change the setting using the following approach. Modify the SmartList, chose the amount field, click on the blue arrow and move to the Decimals tab, and change the setting to Constant and 2. Please see the screen shot below:
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156