Forum Discussion
CeceliaMartin
Qrew Cadet
Close, but I am getting an error on the last line. And when entering any other type of number the color does not change.
On Time Shipping % is a numeric field.
What I am creating is a rich text formula. Is that correct?
If([On Time Shipping %]<99,"<span style='font-size: 15pt; text-align: left; color: green'>" & ToText([On Time Shipping %]) & "</span>",
If([On Time Shipping %]>92,"<span style='font-size: 15pt; text-align: left; color: red'>" & ToText([On Time Shipping %]) & "</span>",
If([On Time Shipping %]>=98&<=93,"<span style='font-size: 15pt; text-align: left; color: yellow'>" & ToText([On Time Shipping %]) & "</span>" )))
On Time Shipping % is a numeric field.
What I am creating is a rich text formula. Is that correct?
If([On Time Shipping %]<99,"<span style='font-size: 15pt; text-align: left; color: green'>" & ToText([On Time Shipping %]) & "</span>",
If([On Time Shipping %]>92,"<span style='font-size: 15pt; text-align: left; color: red'>" & ToText([On Time Shipping %]) & "</span>",
If([On Time Shipping %]>=98&<=93,"<span style='font-size: 15pt; text-align: left; color: yellow'>" & ToText([On Time Shipping %]) & "</span>" )))
DavidBrogdon
6 years agoQrew Assistant Captain
Shouldn't this really be (pseudo) --->
If value > 0.99, red
else if value <=0.99 and value >=0.93, yellow,
else, green
Reason being that 0.99 is going to be greater than 0.98 and also it will be impossible for the value to be greater than 0.98 but less than 0.93? Also, all values above will be greater than 0.92?
If value > 0.99, red
else if value <=0.99 and value >=0.93, yellow,
else, green
Reason being that 0.99 is going to be greater than 0.98 and also it will be impossible for the value to be greater than 0.98 but less than 0.93? Also, all values above will be greater than 0.92?