Dollar sign ($) in text box format rounds decimals?

AlexWiley

I searched for awhile and could not find a similar post. I'm trying to add a dollar sign to the total amount of an invoice. In the source expression I have:

TempSalesInvoiceLine."Amount Including VAT"

and the amount appears correctly as "92.20". However, when I add:

'$' + FORMAT(TempSalesInvoiceLine."Amount Including VAT")

It displays "92.2". It is also making the value show up with Left horizontal orientation, despite being set at Right. When I add the '<Precision,2:2><Standard Format,0>' before the source information it gives me an Overflow error on the 92.2 value. I could work around it by putting a '$' label in front of the textbox, but I would like something cleaner if possible.

raven44

you could always try:
strsubstno('$%1',TempSalesInvoiceLine."Amount Including VAT")
--scrap that--didnt read about the decimals properly

kapamarou

Go to the textbox properties and on the format property write :
$<Sign><Integer Thousand><Decimals,3>

AlexWiley

kapamarou wrote:

Go to the textbox properties and on the format property write :
$<Sign><Integer Thousand><Decimals,3>

Works perfectly! Thank you!

kapamarou

You're welcome.