Format number as dollars

[mleiser]

Is there a way to format a number into dollars and cents with dollar sign, not in the layout, but in the database or email message, where I ultimately need it? TIA

[comment]

This has been covered several times - here's one I found quickly:
https://fmforums.com/topic/78003-setting-number-of-significant-figures/?do=findComment&comment=365265&_rid=72594

Another option is to format the field on the layout, and use the GetLayoutObjectAttribute() function to get the formatted content into a script/calculation.

 

[mleiser]

Thanks so much. I did do a search but I guess I didn’t ask the right question. Thanks again. The function will be perfect.