如何在Acumatica报表设计器中格式化数字 [英] How to format number in acumatica report designer
问题描述
我遇到了有关格式编号的问题,我想将000.00删除为000,例如150000变成150,000
要删除小数,可以使用此格式字符串:
='#。'
要删除小数点并使用逗号作为千位分隔符:
='## #,###,###,###,###,###。'
有关Microsoft .Net格式化系统的更多信息此处提供数字类型的ntax:
https://docs.microsoft.com/zh-cn/dotnet/standard/base-types/custom-numeric-format-strings
I got some issue about format number, I want to remove 000.00 to 000 and for example 150000 become 150,000
Acumatica report designer supports Microsoft .Net format syntax.
To use it, select a field in the report designer and assign it a Microsoft .Net format string: To remove decimal you can use this format string:
='#.'
To remove decimal and use a comma as a thousand separator:
='###,###,###,###,###,###.'
More information about the Microsoft .Net formatting syntax for numeric types is available here: https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-numeric-format-strings
这篇关于如何在Acumatica报表设计器中格式化数字的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!