AnsweredAssumed Answered

Forcing decimal points

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

Title

Forcing decimal points

Post

Hello,

 

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.

 
Thanks!

Outcomes