AUGForums.com

An Acumatica User Group

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

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

Forums
AUG Forums
Acumatica Report De...
Formatting a number...
 
Notifications
Clear all

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

 
Acumatica Report Designer
Last Post by Royce Lithgo 2 years ago
9 Posts
5 Users
4 Likes
7,719 Views
RSS
fozzie
Posts: 34
 fozzie
Topic starter
June 17, 2017 10:20 am
(@fozzie)
Trusted Member
Joined: 7 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: 3096
 Tim Rodman
Admin
June 17, 2017 10:24 am
(@timrodman)
Famed Member
Joined: 8 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: 4 years ago

Trusted Member
Posts: 33
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)
Trusted Member
Joined: 7 years ago

Will do. Thanks Tim.

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

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

Reply
JustPaul
Posts: 33
 JustPaul
July 30, 2017 10:12 pm
(@justpaul)
Trusted Member
Joined: 4 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: 3096
 Tim Rodman
Admin
July 30, 2017 10:39 pm
(@timrodman)
Famed Member
Joined: 8 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
Donna Boes
Posts: 27
 Donna Boes
April 28, 2022 11:24 am
(@bodonna)
Eminent Member
Joined: 6 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
Foujan Khazaee reacted
Royce Lithgo
Posts: 557
 Royce Lithgo
April 28, 2022 7:09 pm
(@roycelithgo)
Honorable Member
Joined: 4 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
Donna Boes and Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,388 Topics
  • 10.4 K Posts
  • 2 Online
  • 2,019 Members
Our newest member: Dulanjana Senevirathne
Latest Post: PDM vault conisio link
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

 No online members at the moment

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.

‹›×

    ‹›×