This post inspired me to make this product suggestion.
We already have the DATETIME_FORMAT function, which lets us use a formula field to reformat the data from a date-type field into a text string of our specifications.
But it would be really great to have that exact same ability to reformat a number field or a currency field into a text string of our specifications.
For example, take these 2 fields:
Currency Field — formatted as currency with $ sign and precision of 2 decimal points
Number Field — formatted as decimal with precision of 4 decimal points
If we put these 2 fields into a formula that results in anything other than a single number result, they lose all of their formatting.
So instead of a desired sentence which looks something like this:
“You bought 0.4500 pounds at $2,200 each.”
The formula currently looks like this:
“You bought 0.45 pounds at 2200 each.”
We can easily add in the dollar sign, but adding in the commas and trailing zeros is harder to do in a calculation.