AnsweredAssumed Answered

Preserving fixed number of decimal places when converting to text

Question asked by johnhorner on Nov 18, 2009
Latest reply on Nov 21, 2009 by johnhorner

Title

Preserving fixed number of decimal places when converting to text

Post

i have a calculation field (ItemSubtotal) which returns the numeric result of multiplying an item qty and an item price.  if i am using us dollars i can simply format the field to preserve 2 decimal places and show a dollar sign.  however, if the invoice is set up for a foreign currency (say, euro for example), i use a different layout to print the invoice and this layout contains a calculation field that returns a text result (e.g. ItemSubtotalForeignCurrency = ItemSubtotal & CurrencySymbol).  so far this all works fine.  the problem arises when the subtotal is an even amount (i.e. no cents, just dollars/euros/pounds, etc, such as 100€) and then it does not display the decimal places.  i want it to display the result as: 100.00€.  does anyone know how to do this.  any help much appreciated.

Outcomes