I would like the value to display as a currency with 0 decimal places and comma separators.
However, when I used a formula like CInt(x), it still showed 1,111.00, so I would like it displayed as 1,111. I also created a new field decimal type (19,0) and selected it in the schema field, it still showed the same like1,111.00. Is there any suggestion? Thanks!
Solved
GI field format
+13If you’re writing code, [PXDBDecimal(0)] should work.
Daryl ⚡Contract Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
+19Hello,
It’s helpful to see your GI, at least a screenshot. If we know what tables you are using, or what type of data you are reporting, we can better recommend a schema field to use for numeric formatting.
Laura
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
darylbowman wrote:
If you’re writing code, [PXDBDecimal(0)] should work.
It works! thanks a lot
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.