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!
Answer
GI field format
Best answer by darylbowman
If you’re writing code, [PXDBDecimal(0)] should work.
+15If you’re writing code, [PXDBDecimal(0)] should work.
Daryl⚡Freelance Acumatica Developer (MVPx2🏆) 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 Barber, WM Synergy
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.