By using this website, you agree to our Terms of Use (click here)
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
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?
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.
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
Will do. Thanks Tim.
What about keeping your Format formula, but multiply the number by 100 to get rid of the decimals?
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.
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.
I was able to do this in the dunning letter using this formula. Format('{0:#,###.00}',Sum( IIf([ARDunningLetterDetail.Overdue], [ARDunningLetterDetail.DocBal],0 )))
@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.
Online Members
