Acumatica Report Designer Format Decimal Points

Question

Can anyone tell me what is the Format required to get decimal points to be displayed dynamically so that the field displays "5" if I enter "5.0" and "5.5" if I enter "5.5" automatically.

I have tried using #0.# as the format, but this is leaving the "." as in "5." if I enter "5.0". I have left the field as "#0.0" but would really like to know if there was a way of dynamically change the decimal places this way

Answer 1

I figured out the answer was ##.# :)

Answer 2

You can pull in the correct decimals for quantity and cost as specified on the Branch record by using a database field and an expression.

=Report.IntToUI('AMMTran.UnitCost',CDec([AMMTran.UnitCost]))

Answer 3

you can use the following formula too:
=Format('{0:0.#}', 5.5)