Forum Discussion

StephenJackson's avatar
StephenJackson
Qrew Member
3 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
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
3 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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    Stephen,
    Did you try simply setting the format of your Summary Formula

    Step 2: Write summary formulas

    Use your variables as you would normally use fields. For example, an Income formula might be "[Revenue (tot)] - [Expense (tot)]".

    Summary Formula 1  Numeric - Currency


    [Invoice Amount (tot)] / [Number of Time Records]


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------