Hello all,
I have been working on a report & i am looking to hide the decimals. So for example i have an amount of 1234.56 displaying in the report, now all I want is to round it up & display as 1235 and not display as 1235.00
How can I achieve this?
I have this formatting applied:
Best answer by lauraj46
Hi
The Acumatica Report Designer supports Microsoft .Net format syntax. In your formatting string you can replace ###,###,##0.00 with ###,###,##0. This will round and remove the decimals.
https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-numeric-format-strings
Hope this helps!
Laura
+3Hi
Have you tried with ='#.' in the Format Section.
Hope, it helps.
Regards,
Sagar, Greytrix
+8Hi
The Acumatica Report Designer supports Microsoft .Net format syntax. In your formatting string you can replace ###,###,##0.00 with ###,###,##0. This will round and remove the decimals.
https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-numeric-format-strings
Hope this helps!
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
