Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Formatting numbers in a formula

Topic Labels: Formulas
2933 2
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I format the results of a numeric formula? For instance for a formula that sums a number of values from fields in my table into a new numeric field, how can I generate a “$” in front of those values automatically, and possibly format the numbers with a comma for a thousands separator?This is my working sum formula:

SUM({WC Revenue},{GL Revenue},{GH Revenue},{CP Revenue},{CA Revenue},{EPLI Revenue},{D&O Revenue},{PL Revenue},{KMLI Revenue},{LI Revenue},{HFLH Revenue},{EL Revenue},{GK Revenue},{ProL Revenue},{HO Revenue},{PA Revenue},{Bond Revenue},{Payroll Revenue})

Anything I can add to this to generate the “$” and/or the thousands separator?

Thanks!

2 Replies 2

When editing the formula, above the formula field is a “Formatting” tab. Click that and you can choose from several formatting options, one of which is Currency.

Oh awesome! I totally forgot that was there. Thank you!