AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Generic I...
Removing Decimals f...
 
Notifications
Clear all

Questions Removing Decimals from Numbers in Pivot Tables

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by piggy 9 years ago
3 Posts
2 Users
1 Reactions
3,954 Views
RSS
piggy
Posts: 36
 piggy
Topic starter
June 4, 2017 9:55 pm
(@piggy)
Trusted Member
Joined: 9 years ago

Hi Everyone,

I'm trying to make my Pivot Table columns smaller because I have a lot of columns and I'm running out of space.

I don't really need the decimals to be displayed on my numbers.

Does anyone know if I can format my numbers to show whole dollars without the decimals?


2 Replies
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
June 4, 2017 10:00 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Hi Piggy,

Yes, you can do this. Just highlight the field that you want to format and put #,### in the Format field. If you wanted to include the decimals, the format code would be #,###.00

Acumatica Version 6.10.0472 used when composing this response

Reply
piggy
Posts: 36
 piggy
Topic starter
June 4, 2017 10:01 pm
(@piggy)
Trusted Member
Joined: 9 years ago

Hey, that was easier than I thought it would be. Actually, I was worried that it couldn't be done. This is great, thanks!


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,530 Topics
  • 11 K Posts
  • 11 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Negative/Credit Inventory Value?
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • Johnny Tang
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×