Acumatica Summit 2026 - January 25-28 | Seattle Convention Center — Summit Building
Report:
Exported to Excel:
I currently use P as format in column set.
Best answer by Laura03
Hello,
Did you try 0.##%?
What options did you try?
Hello @kristianharianja ,
I did a test and the % stays formatted in this report, when exported to Excel:
The Column Set looks like this:
Row Set has no formatting:
Hope this helps you.
Thanks @laura01 that works however when the percentage value below 1% the leading zero is missing. What's format to also retain the leading zero?
Did my suggestions above work out for you? If not please let us know so we can assist. Thank you!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.