AnsweredAssumed Answered

Forcing decimal points

Question asked by Matty_1 on May 22, 2012
Latest reply on May 22, 2012 by philmodjunk


Forcing decimal points




I have a text field where I display USD when we have a US customer and simply a dollar sign infront of the the total when we deal with our canandian customers.

If (InterimContacts::Currency = "USD";
"USD$" & Round(SubTotal+LevyCalc+PriceAdjustment;2);
"$" & Round(SubTotal+LevyCalc+PriceAdjustment;2))

The problem with my formula is that I used to use the data formatting in the inspector to force fthe required decimal points and left the feidl as a number field. I've now been asked to include the USD and can seem to narrow it down just right.