AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Formatting a number...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions Formatting a number as a whole number in Acumatica Report Designer

Acumatica Report Designer
Last Post by Royce Lithgo 9 months ago
9 Posts
5 Users
3 Likes
6,802 Views
RSS
fozzie
Posts: 34
 fozzie
Topic starter
June 17, 2017 10:20 am
(@fozzie)
Member
Joined: 6 years ago

Hi Everyone,

Is it possible to display a number as a whole number without the decimals in Acumatica Report Designer?

I used the following formula to round the number and get rid of the decimals. 

=Round([ARTran.NetSalesAmount],0)

But the decimals .00 still get displayed for all of the numbers.

Is there a way not to display the .00?

8 Replies
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
June 17, 2017 10:24 am
(@timrodman)
Member
Joined: 7 years ago

Hi Fozzie,

You can go to the properties of the field in Report Designer and put the following code in the Format field:

#,##0

That should set it to display without the decimals.

Make sure though to use the round function that you're using as well. Otherwise I think it will just chop off the decimals for display without doing the rounding.

Reply
Arline Welty reacted
JustPaul
 JustPaul
(@justpaul)
Joined: 3 years ago

Member
Posts: 31
July 30, 2017 10:15 am
Reply toTim RodmanTim Rodman

Tim.

similar situation.  

I am attempting to build a flat file that will be uploaded to bank for positive pay.

the dollar amount cannot show comma or decimal, but not round.  it would also show zero fill for 15 characters total.  125.24 becomes 000000000012524

i thought format([field],000000000000000) might do it, but the decimal is still displaying. 

because this is part of a flat file, it is only one field in a string of other fields.  so adjusting the field format, i don't think would work.  

im beginning to think it isn't possible.

thanks for your assistance.

Paul

Reply
fozzie
Posts: 34
 fozzie
Topic starter
June 17, 2017 10:24 am
(@fozzie)
Member
Joined: 6 years ago

Will do. Thanks Tim.

Reply
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
July 30, 2017 9:38 pm
(@timrodman)
Member
Joined: 7 years ago

What about keeping your Format formula, but multiply the number by 100 to get rid of the decimals?

Reply
JustPaul
Posts: 31
 JustPaul
July 30, 2017 10:12 pm
(@justpaul)
Member
Joined: 3 years ago

I was thinking the same thing.  

 

But also.  Is it possible to format the fields individually, then create a text box or calc field then bring all the individually calculated fields together,. Instead of formatting and stringing The results at the same time.  Might the option be easier or not.  

I have years of Crystal and SSRS, but not very much at all with Report Designer.  

Thanks. 

Reply
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
July 30, 2017 10:39 pm
(@timrodman)
Member
Joined: 7 years ago

So you want to be able to reference the result of a Text Field calculation in another Text Field? That would be nice, but it isn't possible as far as I know.

I think you might be able to do this in Crystal, but Report Designer is nowhere near as robust as Crystal.

Reply
Bodonna
Posts: 27
 Bodonna
April 28, 2022 11:24 am
(@bodonna)
Member
Joined: 5 years ago

I was able to do this in the dunning letter using this formula.  Format('{0:#,###.00}',Sum( IIf([ARDunningLetterDetail.Overdue], [ARDunningLetterDetail.DocBal],0 )))

Reply
Royce Lithgo
Posts: 544
 Royce Lithgo
April 28, 2022 7:09 pm
(@roycelithgo)
Member
Joined: 3 years ago

@bodonna, the discussion was about referencing the result of a textbox from the formula of another textbox. Your formula is referring to data fields. It's not the same thing.

What @timrodman said is still true, you can't reference the result of a textbox value from another textbox. Even though textboxes have unique ids in report designer, there's still no way to reference the value by the id. 

Reply
Bodonna and Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,236 Topics
  • 9,868 Posts
  • 2 Online
  • 1,812 Members
Our newest member: Heather Jones
Latest Post: Sales Order Comment Lines / Memo / Note Lines
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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×