I am trying to connect the following codes to work together. The way it's constructed one code will work but not the other, this is also true when the code is reversed. The 1st part of the code represents a change in the percentage and the 2nd part of the code calculates the actual percentage.
The percentage is formatted as "00.00% When it exceeds 80.00%, I need it to change color and the same for over 90.00%
if (LTV1st > 80)then
LTV1st.fillColor = "239,122,242"
elseif ($ > 90) then
LTV1st.fillColor = "110,0,0"
else LTV1st.fillColor = "208,208,208"
If(FirstLien>0 and SalesPrice>0) then LTV1st = FirstLien / SalesPrice;
I'll take a look at the form. Thanks again. Just to be clear, i'm not dividing 500.000 by 450.000. I'm dividing $450,000.00 (Four hundred and fifty thousand dollars) into $500,000.00 (Half a million dollars) to get 90.00%.