How can I use numeric data and still have the benefits of HTML color coding tags?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I am using a formula text field with HTML tags. My data is numeric yet using the formula text field seems to prevent me from being able to summarize my data. How can I use the color coding benefits of text formulas with HTML tags yet be able to summarize my numbers?

Here is the formula that I am using:

If([Total GP/L] < 0,      "<div style=\"color:white; background-color:#FF0000 ;\">" & [Total GP/L] & "</div>", 

[Total GP/L] < 15000, "<div style=\"background-color:#E6F728;\">" & [Total GP/L] & "</div>",

[Total GP/L] < 50000, "<div style=\"background-color:#F7CE28;\">" & [Total GP/L] & "</div>",

[Total GP/L] > 50001, "<div style=\"background-color:#2C572D;\">" & [Total GP/L] & "</div>", "")
Photo of Nick

Nick

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 64,518 Points 50k badge 2x thumb
You can't.  You will need to either use row colorization or icons to indicate a color "status".  Like you said, a text field cannot be used  and expect a total at the bottom of a table report.