Curency formatting...

[ConnieHull]

I am working on having FM8 send an e-mail to 1 person based on information in 1 record. The problem I'm running into is a number field that is: Grand Total (a calculation field) with the calculation set to: SetPrecision ( Subtot + Tax; 2 ) it is leaving the 0's off the end if it is $163.90 then it displays $163.9 if it's $163.00 then it displays $163 ... I know that setting the field formatting to display it properly in the layout but the formatting is not copying over to the e-mail.

Any suggestions on how to achieve this would be greatly appreciated.

If there is a more appropriate place to post this please let me know as well, I'm new at forums and although I've worked with FM in the past I would barely consider myself a novice.

[fabriceN]

Try this http://www.briandunning.com/cf/615

(it's a simple calc you can use in a field rather than in a CF)

Edited December 12, 2007 by Guest

[ConnieHull]

Thanks for the suggestion... One problem I don't have FM Advance, I have FM Pro 8. Is there anyway to add this to my custom functions without having Advance?

Or does anyone have a way to do what I'm looking for in Pro?

[Lee Smith]

Hi Connie, and welcome to the Forum.

As Fabrice said, you can set this up in a normal calculation field, mos CFs can be done in this way.

I made you a quick demo of how.

HTH

Lee

ConnieHull.fp7.zip

Edited December 12, 2007 by Guest

[ConnieHull]

Thanks!

This worked for me, and I greatly appreciate the example. With it I was able to figure it out. Thanks again!