CODEWITHSUNDEEP
reportacumatica
GaGa
GaGa

Reputation: 209

Acumatica Report Designer Format Decimal Points

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

Upvotes: 1

Views: 2371

Answers (3)

Sam
Sam

Reputation: 41

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

Upvotes: 1

Dennis Godsill
Dennis Godsill

Reputation: 11

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]))

Upvotes: 1

GaGa
GaGa

Reputation: 209

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

Upvotes: 1

Related Questions