Forum Discussion

IanIan's avatar
IanIan
Qrew Member
9 years ago

Conditionally change color of formula numeric field, either text or background, without using a a Formula Text field.

I want to change either the background or text of a formula numeric field based on conditions (e.g. over budget). I have made it work using a formula text field that mimics the number, and even got a ...
Formulas and functions
reports and charts
Tables and fields
ArchiveUser's avatar
ArchiveUser
Qrew Captain
9 years ago
It would be done in the same way that you outlined in your example, except that the value presented would be a Text value. To change the background, this is the example (albiet with numeric values) that I've used:

If(Round([numeric])<[numeric goal],"<div style=\"background-color:pink;width:50\">"&ToText(Round([numeric]))&"</div>",ToText(Round([numeric]))