Formatting numbers in a formula

Topic Labels: Formulas
4556 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?


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!