Forum Discussion

Del's avatar
Del
Qrew Cadet
4 years ago

Add"$" to rich text field

I am looking to add a "$" to a rich text field as I am actually color coding a numeric field. I have the formula below


If( [Field 1] > 1,
"<span style='background-color: #ffb3b3'>" & Round ([Field 1]),
ToText (Round(([Field 1]))))

------------------------------
D
------------------------------
Formulas and functions
Tables and fields

5 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    try this

    If( [Field 1] > 1,
    "<span style='background-color: #ffb3b3'>" & "$" & ToText(Round ([Field 1])),
    "$" & ToText (Round(([Field 1]))))

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • Del's avatar
      Del
      Qrew Cadet
      4 years ago
      Works, thank you!

      ------------------------------
      Ermias Bean
      ------------------------------
    • Del's avatar
      Del
      Qrew Cadet
      4 years ago
      Also need to add commas to the numbers. And is there a way to add a running totals column?

      ------------------------------
      Ermias Bean
      ------------------------------
      • DonLarson's avatar
        DonLarson
        Qrew Commander
        4 years ago
        Ernias,

        Can you give an example of the underlying data and how that would be used in a running total?

        Don

        ------------------------------
        Don Larson
        Paasporter
        Westlake OH
        ------------------------------