Forum Discussion

IanIan's avatar
IanIan
Qrew Member
8 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
IanIan's avatar
IanIan
Qrew Member
8 years ago
OK, I got this to work from an earlier post from Mark.

If([Remaining Hours Original] >0,
ToText(Int([Remaining Hours Original]))
& "."
& If(Int([Remaining Hours Original])=[Remaining Hours Original],"0",
     Length(Right(ToText([Remaining Hours Original]),"."))=1,Right(ToText(Frac([Remaining Hours Original])),1) & "0",
     Right(ToText(Frac([Remaining Hours Original])),".")))

I also want to conditionally change the color. How do I add that? thanks