Forum Discussion

BethanyHudson's avatar
BethanyHudson
Qrew Trainee
4 years ago

Formatting Commas to a Currency Formula Field

I've got a summary report with a report formula that is currency. How do I get the commas to show in the field?

------------------------------
Bethany Hudson
Program Administrator
Mobile Bay National Estuary Program
Mobile AL
2514598870
------------------------------
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    np,
    Just edit the field properties for the field and you can configure to have commas and also i like to have them how after 3 places, not 4.

    If you leave it set up as commas after 4 digits, then for their numbers as high as 9999 will not have decimals. The decimals would only start at 10,000.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------