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. 

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

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. 

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(,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

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

#,##0

https://i.imgur.com/7b1GV0b.png

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.

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(,0)

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

Is there a way not to display the .00?