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
+17If you’re writing code, [PXDBDecimal(0)] should work.
Translate
+20Hello,
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
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.