StephenJackson
3 years agoQrew Member
Commas added to currency numeric field summaries
In a Summary Report, I am trying to make the 'Report formula' columns display with a comma added every three digits. ex: $1,234,321.00 instead of $1234321.00
The 'Report formula' is summarizing a Numeric - currency field as Formula - Numeric. The Numeric - currency field's properties is formatted to include these commas. The commas appear when I look at an individual record. But the 'Report formula' column does not display them on the Summary Report.
I have tried: ToFormattedText([Number - currency field], "comma_dot") but it receives an "expecting number" error.
If add ToNumber at the beginning of that formula, it displays the value without the commas.
Changing the 'Report formula' to a Formula - Text means I can't summarize the total. I can only count distinct values.
Any ideas as to how I can add the commas?
#Formulasandfunctions
#reportsandcharts
------------------------------
Stephen Jackson
------------------------------
The 'Report formula' is summarizing a Numeric - currency field as Formula - Numeric. The Numeric - currency field's properties is formatted to include these commas. The commas appear when I look at an individual record. But the 'Report formula' column does not display them on the Summary Report.
I have tried: ToFormattedText([Number - currency field], "comma_dot") but it receives an "expecting number" error.
If add ToNumber at the beginning of that formula, it displays the value without the commas.
Changing the 'Report formula' to a Formula - Text means I can't summarize the total. I can only count distinct values.
Any ideas as to how I can add the commas?
#Formulasandfunctions
#reportsandcharts
------------------------------
Stephen Jackson
------------------------------