Forum Discussion

StephenJackson's avatar
StephenJackson
Qrew Member
4 years ago

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 N...
Formulas and functions
reports and charts
StephenJackson's avatar
StephenJackson
Qrew Member
4 years ago
Hi Matt,

Thanks for your help!!

Your solution is still gives me an error where it says "Expecting number but found text" if the Report formula is a Formula - Numeric. 

Or if I change it to Formula - Text, it'll only summarize by Distinct Count in the Summarize Data section. 

Any ideas?

It

------------------------------
Stephen Jackson
------------------------------
MattHardy's avatar
MattHardy
Qrew Trainee
4 years ago
Unfortunately, I misunderstood your original question and can't offer any more suggestions. Hopefully, someone else comes along with an answer for you.

------------------------------
Matt Hardy
------------------------------