I am using the code below to change color to a calculated percentage feld; example, if the field is greater than 80.00% than the color should be "239,122,242".
This code only works for the "else" part, the color change is not working. Ihave tried using the name of the field, % of the field, $ but I cannot figure it out. The code has been placed in the calculate event in formcalc.
Thanks.
if ("%" > 80)then
LTV1st.fillColor = "239,122,242"
elseif ($ > 90) then
LTV1st.fillColor = "110,0,0"
else LTV1st.fillColor = "208,208,208"
endif
If(FirstLien>0 and SalesPrice>0) then LTV1st = FirstLien / SalesPrice;
endif